How to apply "Cr" "Lacs" logic to null values.

[sandeepj13]

Hi,

The below logic for showing values in Cr, Lacs and Abs is not getting applied for Null values. Because of which when we select "Cr" the pie chart shows the null values as the highest share and rest value as minuscule.

Num(

sum([Order Value])

/

if(Currency='Cr',10000000,

if(Currency='L',100000,

1))

,'#,##0.00'&if(Currency='Cr',' Cr',

if(Currency='L',' L'))

)

Regards,

Sandeep Joglekar

[agni_gold]

So what you want instead of null ,

In this condition , you should first check ISNULL condition then your expression ,

Send sample file , it will easy to help you.