Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
vinayk1
Contributor

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

1 Solution

Accepted Solutions
vinieme12
Champion III

use Coalesce()

=Coalesce(  YourExpression , "" )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

5 Replies
BrunPierre
Partner - Master

Are you looking for something like this?

If([calulated value]=0,NULL(),[calulated value])

vinayk1
Contributor
Author

Actually, 
 if denominator =0 then 0 else calculation

 

Rams-
Creator

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!

 

vinieme12
Champion III

use Coalesce()

=Coalesce(  YourExpression , "" )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinayk1
Contributor
Author

Thanks a lot, 

This worked for me.