NEGATIVE AMOUNTS

[Anonymous]

Hello,

I try to extract only the negative amounts of a dimension in which positive, negative and also 0 amounts are mixed.

Could you please tell me the method to encode.

Thanks in advance.

Kind regards.

[MarioCenteno]

Try this

Dimension

=if( aggr((sum(SALES))<0),NAME_CLIENT), NAME_CLIENT,'OThers')