Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this
Dimension
=if( aggr((sum(SALES))<0),NAME_CLIENT), NAME_CLIENT,'OThers')