Good afternoon,
I would like to place the total value of line item '%' in line item 'A'. In other words, I would like the amount 17,259 to appear in all the fields, but I haven't been able to do it. Could you tell me the formula to achieve it?
Β
@CarlosRodΒ
If the total is at the top level then use SELECT. If it's a parent level use LOOKUP. You'll need to use a system module for this.
A = %[LOOKUP: SYS01.Parent]
I'm working on a model with three versions: Actual (Actual version), Scenario: Prognose lopend jaar (current version), and Scenario: Budget volgend jaar. For one of the calculations, the Scenario: Prognose lopend jaar version needs to use a different current period than the Scenario: Budget volgend jaar. For this, Iβ¦
Does anyone have any documentation on the trade-offs of having 1 model for all components of planning (service revenue, product revenue, labour planning), vs multiple models 1 for each and a consolidation model to tie it all together?
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-yearβ¦
