Forum Discussion
Displaying upgrade costs based on multiple factors
After some screwing around I ended up creating two calculated columns in Devices that returned 0 or 1 based whether or not the device needed an upgrade and had a Module. Then I created a column with a nested if statement that looks something like this.
UpgradeCost = IF( AND(Devices[UpgradeReqd]=1, Devices[HasModule]=0 ), 660,
IF( AND(Devices[UpgradeReqd] = 1, Devices[HasModule] = 1 ), 550,
IF( AND(Devices[UpgradeReqd] = 0, Devices[HasModule]=0 ), 110, 0
)
)
)
Eliminates the need for the Upgrade Costs table but now everything is hard coded.
Fortunately the numbers won't change for sometime.
After some screwing around I ended up creating two calculated columns in Devices that returned 0 or 1 based whether or not the device needed an upgrade and had a Module. Then I created a column with a nested if statement that looks something like this.
UpgradeCost = IF( AND(Devices[UpgradeReqd]=1, Devices[HasModule]=0 ), 660,
IF( AND(Devices[UpgradeReqd] = 1, Devices[HasModule] = 1 ), 550,
IF( AND(Devices[UpgradeReqd] = 0, Devices[HasModule]=0 ), 110, 0
)
)
)
Eliminates the need for the Upgrade Costs table but now everything is hard coded.
Fortunately the numbers won't change for sometime.