## how to do variance in list items.

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

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

Thanks,

Uday

+917411158778.

3 REPLIES 3
Master Anaplanner/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

Highlighted
Occasional Contributor

## Re: how to do variance in list items.

Hi David,

Thanks for the quick response its working fine.

Thanks,

Uday.

Highlighted
Master Anaplanner/Community Boss

## Re: how to do variance in list items.

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