Hi - Please could you help me tidy this forumla so that its accepted by Anaplan?
IF Type = Supplier Type.Purchase Order (IF 'Forecasted total Value £ (E)' - 'Supplier PO Value (B4)' > 0 THEN 0 ELSE 'Forecasted total Value £ (E)' - 'Supplier PO Value (B4)')
OR Type = Supplier Type.Subcontractor (IF 'Forecasted total Value £ (E)' - 'Original Contract Value (B1)' - 'Agreed Variation Value (B2)' - 'Draft Variation Value (B3)' THEN 0 ELSE 'Forecasted total Value £ (E)' - 'Original Contract Value (B1)' - 'Agreed Variation Value (B2)' - 'Draft Variation Value (B3)')
