Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to know the sales values when Top BU is null. I tried the below expression but it is not working.
sum({<[Top BU]={"$(=IsNull([Top BU]))"}>}Sales).
I would like to have your suggestions to correct my expression.
Try this
sum({<[Top BU] ={'=$(=len([Top BU])=0)'}>}Sales)
I think suggestions from AMnish Kachhia, rgv rand , Anil Babu should be worked.
But they did not work for me, not sure maybe because of the model I have.
Good article to know about the 'NULL'.
However, I solved my problem by adding the below calculated dimension without changing anything in the expression.
if(IsNull([Top BU]),'Yes'), and checked the option "Suppress when value is NULL"