how to do variance in list items.

RISINGSTAR

Hi All,

how to get the values form one module to another module in list items using subtracting function.

Please find the attached Screenshots TW 28.jpg TW 30.jpg

list items formula given bellow:

Base-Base

Base- Simulation 1

Base-Simulation 2

we have using bellow formula

IF ITEM(Snapshot Versions) = Snapshot Versions.Base THEN 'TW28: What If Snapshots'.Revenue[SELECT: Snapshot Versions.Base] - 'TW28: What If Snapshots'.Revenue[SELECT: Snapshot Versions.Base] ELSE IF ITEM(Snapshot Versions) = Snapshot Versions.'Simulation 1' THEN 'TW28: What If Snapshots'.Revenue[SELECT: Snapshot Versions.Base] - 'TW28: What If Snapshots'.Revenue[SELECT: Snapshot Versions.'Simulation 1'] ELSE IF ITEM(Snapshot Versions) = Snapshot Versions.'Simulation 2' THEN 'TW28: What If Snapshots'.Revenue[SELECT: Snapshot Versions.Base] - 'TW28: What If Snapshots'.Revenue[SELECT: Snapshot Versions.'Simulation 2'] ELSE IF ITEM(Snapshot Versions) = Snapshot Versions.'Simulation 3' THEN 'TW28: What If Snapshots'.Revenue[SELECT: Snapshot Versions.Base] - 'TW28: What If Snapshots'.Revenue[SELECT: Snapshot Versions.'Simulation 3'] ELSE IF ITEM(Snapshot Versions) = Snapshot Versions.'Simulation 4' THEN 'TW28: What If Snapshots'.Revenue[SELECT: Snapshot Versions.Base] - 'TW28: What If Snapshots'.Revenue[SELECT: Snapshot Versions.'Simulation 4'] ELSE IF ITEM(Snapshot Versions) = Snapshot Versions.'Simulation 5' THEN 'TW28: What If Snapshots'.Revenue[SELECT: Snapshot Versions.Base] - 'TW28: What If Snapshots'.Revenue[SELECT: Snapshot Versions.'Simulation 5'] ELSE IF ITEM(Snapshot Versions) = Snapshot Versions.'Final-Selected' THEN 'TW28: What If Snapshots'.Revenue[SELECT: Snapshot Versions.Base] - 'TW28: What If Snapshots'.Revenue[SELECT: Snapshot Versions.'Final-Selected'] ELSE 0

Please Help me to simplify this formula using any other technique or other alternative.

Thanks,

Uday

+917411158778.

Accepted answers

DavidSmith

Simple

'TW28: What If Snapshots'.Revenue[SELECT: Snapshot Versions.Base] - 'TW28: What If Snapshots'.Revenue

David

All comments

DavidSmith

Simple

'TW28: What If Snapshots'.Revenue[SELECT: Snapshot Versions.Base] - 'TW28: What If Snapshots'.Revenue

David

RISINGSTAR

Hi David,

Thanks for the quick response its working fine.

Thanks,

Uday.

DavidSmith

@RISINGSTAR

I would add that it is possible (and preferable) to avoid the SELECT at all.

If your requirements changed, you would to find all formulas with SELECT

It is best practice to use a module with a line item formatted as Snapshot Versions (let's call it 'Scenario Choice.Compare Scenario')

The formula then becomes

'TW28: What If Snapshots'.Revenue[LOOUKP: Scenario Choice.Compare Scenario] - 'TW28: What If Snapshots'.Revenue

that then allows you to vary the common scenario used in the formula without SELECT

I hope that helps

David

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…