Macro to differentiate between a "0" value and "blank" in a KF cell

[Former Member]

Dear All -

I am trying to write a macro which needs to differentiate between a "0" value and a "blank" in a Key Figure cell (Zero allowed KF) before proceeding to do the further calculations.

Has anyone worked on this logic before in a macro? I would really appreciate some inputs on this one.

Thanks

Mandar

[Former Member · Accepted solution]

Hi,

If you are in V5, this is already taken care of. You just have to select the check box zeros allowed in the planning area configuration for that key figure.

If not, you can make use of the macro function IS_INITIAL()

In case you need to compare value before and after a calculation, try if you can use another planning area keyfigure to compare and do the calculations.

[Former Member]

Visu - Thanks so much for the hint on IS_INITIAL. Not sure how did I miss that one.

We already have set that particular KF to "Zero Allowed" in the Planning Area. I wanted an operator to write a macro to differentiate between a "0" value and a "blank" in that KF and the function suggested works perfect.

Thanks again.

Regards

Mandar

[Former Member]

which version are you on??

also check thread