It's a long one, and there are other variables referenced within it...
((if(GetFieldSelections([Rate Type])='Base Rate',
(1+ ((sum(if($(base_inventory_flag)=1 and $(comp1_inventory_flag)<>1,1,0))
+
sum(if($(base_inventory_flag)=1 and $(comp2_inventory_flag)<>1,1,0))
+
$(base_comp1_win_baserate)
+
$(base_comp2_win_baserate)
)
-
(sum(if($(comp1_inventory_flag)=1 and $(base_inventory_flag)<>1,1,0))
+
sum(if($(comp2_inventory_flag)=1 and $(base_inventory_flag)<>1,1,0))
+
$(base_comp1_loss_baserate)
+
$(base_comp2_loss_baserate)
))
/
($(base_comp1_shops) + $(base_comp2_shops))
)
,
if(GetFieldSelections([Rate Type])='Total Price',
(1+ ((sum(if($(base_inventory_flag)=1 and $(comp1_inventory_flag)<>1,1,0))
+
sum(if($(base_inventory_flag)=1 and $(comp2_inventory_flag)<>1,1,0))
+
$(base_comp1_win_totalprice)
+
$(base_comp2_win_totalprice)
)
-
(sum(if($(comp1_inventory_flag)=1 and $(base_inventory_flag)<>1,1,0))
+
sum(if($(comp2_inventory_flag)=1 and $(base_inventory_flag)<>1,1,0))
+
$(base_comp1_loss_totalprice)
+
$(base_comp2_loss_totalprice)
))
/
($(base_comp1_shops) + $(base_comp2_shops))
)
, Null()
))
))
