Sum of Months not to Deviate from Year Total! Macro

[Former Member]

Experts,

If the user changes a value of key figure in ONE or MORE months ( + or - ), he should be warned of deviation of new sum (Jan to Dec) from the initial total for the months (Jan to Dec). No data should be saved until deviation exists.

Changes are allowed intra months as long as sum total is same as annual (Jan to Dec) sum at start.

How to code this macro?

Thanks

L

[Former Member · Accepted solution]

Hi Loknath,

May be you can consider creating auxiliary key figure and Aux area here for storing the sum of year.

On the basis of comparison of value above,you can create a message using OUTPUT_POPUP() for the same.

Ofcourse the macro has to be assigned as default event,so that as an when you press enter/save/tab the calculation gets carried out in aux key figure (which will be done dynamically and not stored).

Hope this helps.

Thanks & Regards,

Sonali

[Former Member · Accepted solution]

Thank you Sonali, I just noted this response. Something changed in the design in the meanwhile making this need redundant. Nevertheless thanks for your answer. Others might benefit.

[Former Member]

Thank you Sonalee, I just noted this response. Something changed in the design in the meanwhile making this need redundant. Nevertheless thanks for your answer. Others might benefit.