Skip to Content
0

IF condition in disaggregation expression

Jul 13, 2017 at 02:29 PM

48

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers