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
@umandiwa
Could you please share blueprint view of the modules you have on screenshots?
Here is the blueprint view
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
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.
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
