how to do variance in list items.

Occasional Contributor

how to do variance in list items.

Hi All,

 

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

Please find the attached ScreenshotsTW 28.jpgTW 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.

3 REPLIES 3
Community Boss

Re: how to do variance in list items.

Simple

 

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

 

David

 

 

Message 2 of 4
Occasional Contributor

Re: how to do variance in list items.

Hi David,

 

Thanks for the quick response its working fine.

 

 

Thanks,

Uday.

Message 3 of 4
Community Boss

Re: how to do variance in list items.

@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

Message 4 of 4