Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to create a bar chart, but I need to use just a few fields from the table. I've got positive and negative values. I just need positive values, but i don't have any idea for expression. Can anybody give me some tips how to write it?
Thanks,
Aleksandra Siwierska
You can filter out the negative values in a set analysis expression: Sum({<Amount={'>0'}>}Amount)
You can filter out the negative values in a set analysis expression: Sum({<Amount={'>0'}>}Amount)
You can use Gysbert expression
You can also use expression below
RangeMax(Sum(Amount),0)
Gysbert's expression would be an equivalent of this:
Sum(RangeMax(Amount, 0))