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)

    gabriela..zorrilla

      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!