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.

Best Answer

Answers

  • Hi David,

     

    Thanks for the quick response its working fine.

     

     

    Thanks,

    Uday.

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