Hi All,
how to get the values form one module to another module in list items using subtracting function.
Please find the attached Screenshots

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.