2 Replies Latest reply: Nov 22, 2017 11:08 AM by Rene Dimarco RSS

    Aggregation used as filter in Set Analysis

    Rene Dimarco

      Hi everybody,


      I know it´s a simple question but it seems like I can´t solve it myself.


      I have some data that contains a list of invoices owned by a certain company. I want to be able to show only those companies whose invoices total less than a certain amount due, like 100.000, or range, like between 100.000 and 200.000.


      I made an aggregation that works well (alone):


                Aggr(NODISTINCT Sum(TotalOwned), [Client])


      where TotalOwned is the value field of the invoice. It groups all the invoices due by a client and shows the total owned.


      But when I try to use that value as a filter on a set Analysis, I get nothing:


                Sum({$<{"$(=Aggr(Sum(TotalOwned),Client)) < 100000"}>} TotalOwned)


      Any suggestion is welcomed.


      Thanks in advance!