Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.