Special bar chart

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

You can filter out the negative values in a set analysis expression: Sum({<Amount={'>0'}>}Amount)

[satishkurra]

You can use Gysbert expression

You can also use expression below

RangeMax(Sum(Amount),0)

[sunny_talwar]

Gysbert's expression would be an equivalent of this:

Sum(RangeMax(Amount, 0))