Non Zero Expression

[kunkumnaveen]

HI All,

I need a suggestion in framing a expression which should also pick a non zero max value if both zero and non values exist for a selection,

Incase if only one value exist (zero or non zero ) it should show that value

Sample data:

If I select date 20220414 the max value is 0 but it also got non zero values hence it should show max non zero value in a KPI

it should show the highlighted value instead of zero value 

Can any suggestion plz in writing the expression 

[hic]

Try

Max({<Difference-={0.000}>} Difference)

[kunkumnaveen]

Hi Henric,

Thank You for your reply , the above  expression picks non zero max value when there is zero and Non zero values exist for a selection 

The expression should also show up zero values too if there is only one value 

For example :

if I select a date which has only zero value it is showing null in KPI

[hic · Accepted solution]

Try

If(Count(distinct Difference)=1,Only(Difference),Max({<Difference-={0.000}>} Difference))