Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
If(Count(distinct Difference)=1,Only(Difference),Max({<Difference-={0.000}>} Difference))
Try
Max({<Difference-={0.000}>} Difference)
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
Try
If(Count(distinct Difference)=1,Only(Difference),Max({<Difference-={0.000}>} Difference))