Hide negative values in bar chart

[sundarakumar]

Hi all,

Can anyone please tell me how to hide only the negative values in a bar chart?

I dont want them to appear in the chart itself. Where should i give the condition?

-Sundar

[Sokkorn · Accepted solution]

Hi Sundar,

You may look into your expression. Something like If(Sum([Field])<0,Null(),Sum([Field]))

Can you attached your app here?

Regards,

Sokkorn

[VishalWaghole]

Hi Sundarakumar,

Try this expression in ur chart,

=if(sum(Field)>0,sum(Field))

- Regards,

Vishal Waghole

[sushil353]

Hi,

You can remove negative values using dimention limit as well.

In Dimension limits> check option "Show only values that are" > Greater Than , 0 , exact amout

Uncheck "Show Others" from options.

HTH

Sushil