- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Non Zero Expression
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
- Tags:
- @sunny_talwar
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
If(Count(distinct Difference)=1,Only(Difference),Max({<Difference-={0.000}>} Difference))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
Max({<Difference-={0.000}>} Difference)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
If(Count(distinct Difference)=1,Only(Difference),Max({<Difference-={0.000}>} Difference))