making calculated values having zero in denominator, as blank column

[vinayk1]

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

[BrunPierre]

Are you looking for something like this?

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

[vinayk1]

Actually, 
 if denominator =0 then 0 else calculation

[Rams-]

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 · Accepted solution]

use Coalesce()

=Coalesce(  YourExpression , "" )

[vinayk1]

Thanks a lot, 

This worked for me.