Gordon Hughes
asked on
Formula Wrong!!
I want to establish what 20% of a price is
have tried "if {PLUs.TaxCode} = 1 then sum ({PLUPrices.Price}*20%)"
but it does not work
Any ideas?
Gordon
have tried "if {PLUs.TaxCode} = 1 then sum ({PLUPrices.Price}*20%)"
but it does not work
Any ideas?
Gordon
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Mimcc
Thanks for your input
Gordon
Thanks for your input
Gordon
ASKER
All good thanks
ASKER
if {PLUs.TaxCode} = 1 then ({PLUPrices.Price}/10)
Else if {PLUs.TaxCode} = 2 then 0