Dear community,
Would you please have the pleasure for somebody to tell me how can i declare to an IF formula the empty (null) value on a cell?
e.g. I would like to set my disaggregation expression as following:
IF("keyfigure1"=1,give the value "1", otherwise give an empty value)
Just as an input I tried the following but it doesn't work:
IF("keyfigure1"=1,1,NULL)
Thank you very much for your support.
Kind regards
Vasilis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.