Nested aggregations with SUM and IF function

[Kseniya1313]

Dear all,

Some help needed: 

I want to create grouping for the clients which turnover is higher than 10000 €, between 10000 € and 20000 € and etc.

When i type the formula:

=if(sum([SMT.ResultAmount]>0 and sum([SMT.ResultAmount]<10000), 'Group 1'))

I get the notification that Nested aggregations are not allowed.

Can you please please please help? 🙂

Thanks,

Kseniya

[tresesco]

It's possibly because of improper brackets. Try like:

=if(sum([SMT.ResultAmount])>0 and sum([SMT.ResultAmount])<10000, 'Group 1')

[Kseniya1313]

Hi 🙂

Thanks for your reply. tried that version already as well. Get the Invalid dimension from when i close the formula window 😞

[lorenzoconforti · Accepted solution]

If you are using this in a dimension, you need an aggregation function

=aggr(if(sum([SMT.ResultAmount])>200 and sum(SMT.ResultAmount)<300,'Group 1'), ClientID)

ClientID would be your client field; remember also to deselect "Include null values"

[Kseniya1313]

Thanks Master! 🙂