Difference between a KF with value 0 and a KF with no value

[Former Member]

Hi,

I need to compare if a KF has a value equal to 0 or no value at all. I should give them a different output value if so. The data type of the KF is number. In a query, i did not find any formula to find novalue. It seems the system find always 0. I need help. Th you.

[Former Member · Accepted solution]

Lorenza,

No value number key figure is 0. There is no difference between the two.

Regards

Aneesh

[Former Member]

hi,

check those posts maybe there you will find some info

Jean-Emmanuel Birkan

Loading empty value in a key figure ?

Ram Sankaran

Display KF value Zero or Blank with NA

Regards,

Andrzej