AnsweredAssumed Answered

IfElse Formula to Calculate Percentage

Question asked by Cheryl Alderson on Apr 28, 2020
Latest reply on May 4, 2020 by Harald Kuske

Hello, 

 

I'm trying to create an ifelse function that calculates a different percentage of the Contract Price based on the State.

 

I tried the following, but am receiving an error of "Cannot read property 'returnType' of undefined"

 

ifElse(equal($estate_state_c),"QLD"),multiply(0.25,$contract_price_c),

ifElse(equal($estate_state_c),"NSW"),multiply(0.35,$contract_price_c),

ifElse(equal($estate_state_c),"VIC"),multiply(0.35,$contract_price_c)))

 

Can someone point out what I am doing wrong?

 

Thanks in advance!

Outcomes