Switch statement in Indicator field

Advertisement
Switch(([Baseline Cost] - [Actual Cost])/[Baseline Cost] *100 >, "1",
 ([Baseline Cost]  - [Actual Cost])/[Baseline Cost] *100 >10 and ([Baseline Cost]  - [Actual Cost])/[Baseline Cost] *100 <20,"2"))
I have set indicator 1 as green and 2 as red nothing working
Regards, Syed Faizan ur Rehman, CBPM®,PRINCE2®, MCTS
Advertisement

Replay

Thus this should work:
Switch(
( [Baseline Cost] - [Actual Cost] ) / [Baseline Cost]  * 100  <
20 , 1,
( [Baseline Cost] - [Actual Cost] ) / [Baseline Cost]  * 100  >
10 , 2,
True, 3
Hope this helps,
Guillaume Rouyre, MBA, MVP, P-Seller |