Showing rows with negative value

Wed, 25 Nov 2020 16:16:04 GMT

SET vLNegContribution =if(Sum({<ValueName={'Contribution-margin|Margin'}>}ValueSEK) <0, Sum({<ValueName={'Contribution-margin|Margin'}>}ValueSEK));

Hey Guys,

Above works pretty fine it gives me sum of contribution margin and when it's below 0 it outputs that row. all good.

But i would like to show every row where they have negative contribution margin. Not a sum.

Client can have 10 rows 9 of them are minus but as logn as 1 positive row is larger it wont show.

I can take Market as dimension and it shows right values but if I add client it doesnt give me what I want

Is it possible to do this in one table if you understand?

Re: Showing rows with negative value

sunny_talwar — Tue, 23 Aug 2016 14:41:37 GMT

May be try this:

Sum(Aggr(if(Sum({<ValueName={'Contribution-margin|Margin'}>}ValueSEK) <0, Sum({<ValueName={'Contribution-margin|Margin'}>}ValueSEK)), Market))