Dynamic calculation of two Override keyfigure Qty and Percentage

[manikandan_shanmugam3]

Hi All,

Planners want to override Demand Keyfigure dynamically either through Qty or percentage. their selection would be dynamic and choose to override either of keyfigure month by month.

When planner input Override Qty 110, percentage keyfigure should dynamically populate override percentage i.e. 10% in this case, vice versa. It will work with Stored & calc keyfigure for initial scenario as long as one override keyfigure has stored value and other didn't, When user override other keyfigure i.e Percentage keyfigure to 20, it won't populate qty "120" dynamically in Override Qty keyfigure as it has data"110" as stored already.

Is there any other way to achieve this dynamically other than manually deleting data of other keyfigure while override?

Regards,

Manikandan