Hi
We have a setup like this:
Keyfig stat forecast A
Keyfig manual forecast B
Keyfig result C
The logic is that if there is manual forecast then that takes precedence over the stat forecast. We'd like to calculate the result online.
The issue appears whenever people do a manual update on detailed level, and then drill up to see the aggregated result.
In these cases you can't really see the aggregated result since for it to be calculated you need to calculate it for the entire structure of CVCs (considering all the cvcs that has a manual forecast and all the ones where the result is based on the stat forecast).
This can easily be done with a batchjob run on detailed level for the relevant selection. But this is not very elegant and "online" for users.
My question is if there is a way to do it with a macro from a planning book? Could it be possible to make a macro that could be activated via a button that would execute a calculation for all CVCs in the current selection?
I guess what im really asking is if i can replicate the batch functionality in a planning book macro.