11 Replies Latest reply on Sep 24, 2018 8:28 AM by gabriela..zorrilla

    Fixed LOD ranking filter is not working. With WB! (2018.1.3)


      I made a fixed rank like this:


      if RANK(min([FIXED INVOICE ID]),'desc') <= 10 then true else false end


      where i get the latest 10 invoice_id


      fixed_invoice_id is:


      {FIXED [Inv Invoice Id]:

          min([Inv Invoice Id])



      The weighted average i'm getting is considering all the invoices, not just the last 10 even when i filter them.


      Dont know what to do! I attached and example. Any help is welcomed! Thanks!