Expression help !!!

[amit_saini]

Hi Folks,

Below I'm calculation expression as Act Scrap% of Revenue New=sum([Act. Scrap $])/sum([Act Revenue]) , My requirement  Is it possible to show empty space if no value can be calculated? Instead of 0.0% it should show no values (Blank).

Thanks,

AS

[#2]

Hi Amit,

You can have if condition in your expression something like below

=If(sum([Act. Scrap $])/sum([Act Revenue])=0.0,'',sum([Act. Scrap $])/sum([Act Revenue]))

There must be other approach to tackle this, but this is what I got it quick.

Thanks

Arindam

[tresesco · Accepted solution]

Try like:

=If( sum([Act. Scrap $])/sum([Act Revenue])<>0,

     sum([Act. Scrap $])/sum([Act Revenue]),

     null()

)

And then unchech 'Supress Missing' in the presentation tab.