How to recognized a value being fixed within a macro

ukl — Tue, 18 Jan 2022 17:55:21 GMT

Hi there,

I'm using ROW_VALUES_CHANGED() to check for changed values.

I have a requirement where I need to check for values that habe been fixed/unfixed.

IS_FIXED() doesn't help. It only indicates whether or not the value is fixed.

Any ideas?

Thanks

Uli

Re: How to recognized a value being fixed within a macro

planning_is_an_art — Wed, 11 May 2022 18:03:04 GMT

Interesting case. I would try following

1) create a start macro in your planning book and store the info if a cell is fixed or not into a temporary keyfigure (example: value is fixed = 1 , value is not fixed = 0). Depending on how many keyfigures you need to watch this you have to create a temporary keyfigure for every keyfigure accordingly

Forecast Manual --> Temp_ForecastManualFixing

Forecast Adjsutment --> Temp_ForecastAdjustmentFixing

2) depending on when you need the info if a cell has been fix ed or not -create anoher macro to compare the keyfigures with the temp keyfigures and add it to as a Default (every chenge/enter) or as an End Macro (while Saving). In this macro you compare the with IS_FIXED() value with the temp keyfigure to check if a cell has been fixed.

This should work "ok" as long as there are not too many keyfigures and areas to be watched since the permanent comparing after every change (especially as a default macro) might be a little bit performance intensive.

Regards

Thomas

Question Re: How to recognized a value being fixed within a macro in Supply Chain Management Q&A

How to recognized a value being fixed within a macro

Re: How to recognized a value being fixed within a macro