Select formula

umandiwa

How would you use a select formula to collect totals for

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

this module below (totals only)

What formula would I use? Thanks

Accepted answers

All comments

KirillKuznetsov

@umandiwa

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

umandiwa

Here is the blueprint view

bhatjaved

@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

@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.

Quick Links

Can you help?

Unanswered questions

Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
12.4.1 Activity: Create Saved View for Non Employee Expenses
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…