
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
making calculated values having zero in denominator, as blank column
there is a calculation to be displayed in the table chart, it is result of division of two columns in table.
for certain filters the denominator becomes '0' , which leads to calulated values showing '-', how to make sure the calulated values becomes blank when there is zero in denominator
- Subscribe by Topic:
-
Chart
-
dimension
-
expression
-
filter
-
General Question
-
Set Analysis
-
Visualization
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
use Coalesce()
=Coalesce( YourExpression , "" )
If a post helps to resolve your issue, please accept it as a Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Are you looking for something like this?
If([calulated value]=0,NULL(),[calulated value])

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Actually,
if denominator =0 then 0 else calculation

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
you can try this expression: assuming Denum is your Denominator
if(Denum = '0', ' ' and Denum <> '0', Denum)
Hope this helps,
help user find answers ! don't forget to mark a solution that work for you and click the like button!


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
use Coalesce()
=Coalesce( YourExpression , "" )
If a post helps to resolve your issue, please accept it as a Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks a lot,
This worked for me.
