Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i am using htis expression in a chart to show me where i have missing data..
if(isnull(max({<LedgerType={Actual}>}[Issue Date])),
'no data')
How can i use it in a text box to show me the number of occurences where i have no data?
Thanks
this?
Count (if(isnull(max({<LedgerType={Actual}>}[Issue Date])),
'no data') )
Hi, no that doesnt work. that was the first thing i tried.
I can recommend the following resources on NULL values:
I'm pretty sure you'll find a solution in there ...
Regards,
Florian
Hi,
Replace nulls with some character like replace(isnull(ur requirment),'XXX') as Null_Flag
and use count(Null_Flag) ....
I hope it will works.
Regards,
Khadeer
Try this way
max(if(LedgerType='Actual',[Issue Date],'no data'))