Select formula

umandiwa
New Contributor

Select formula

How would you use a select formula to collect totals for 

 

For example I want to fill the base opex row with numbers from

umandiwa_0-1641927741467.png

this module below (totals only)

umandiwa_1-1641927819010.png

 

What formula would I use? Thanks

4 REPLIES 4
KirillKuznetsov
Certified Master Anaplanner

Re: Select formula

@umandiwa 

Could you please share blueprint view of the modules you have on screenshots?

umandiwa
New Contributor

Re: Select formula

umandiwa_1-1641932277853.png

 

 

 

umandiwa_0-1641932215063.png

 

Here is the blueprint view

 

bhatjaved
Frequent Contributor

Re: Select formula

@umandiwa 

 

If you want totals for all periods you can use below formula but if you need values with respect to years than its best to create lookup formula with respect to given years from system module . 

SELECT: TIME. ALL Periods

KirillKuznetsov
Certified Master Anaplanner

Re: Select formula

@umandiwa 

If you need to apply the same value to 'VERSIONS - Opex Forecast Capture'.Amount  then you can simply put 'Upile Test Permian AvB - 10&2 Forecast'.Base Opex in the formula, but this requires you to have both Scenario and L5 Plant dimensions in the target (i could not see Plants on the target module).

Do you mean you have to apply 'Upile Test Permian AvB - 10&2 Forecast'.Base Opex to one of the versions in  'VERSIONS - Opex Forecast Capture'.Amount ?

- if yes, then you have to use IF THEN ELSE statement and check which versions are matching the conditions (you will have to prepare additional module with booleans dimensioned by versions with line items repeating the names of the versions).

 

Otherwise please give us a little bit more details. Because not everything is visible on screenshots.