The goal is this:
1. If US Local = "YES" AND Hourly Rate >=11.01, then Multiply Taxable Dues Amount * 0.22 and Add Initiation Fee Tax Amount, else 5.00
OR
2. If US Local = "NO" AND Hourly Rate >=11.01, then Multiply Taxable Dues Amount * 0.165 and add Initiation Fee Tax Amount, else 5.00
Here's my formula - any suggestions on how to write this to get past the error?
IF(
Order.CVRSOS__Job__r.CVRSOS__HourlyRate__c >=11.01,
IF(Order.Contract.US_Local__c ="YES",
Taxable_Dues_Amount__c *0.22 + Initiation_Fee_Tax_Amount__c,5.00,
IF(Order.CVRSOS__Job__r.CVRSOS__HourlyRate__c >=11.01,
IF(Order.Contract.US_Local__c ="NO",
Taxable_Dues_Amount__c *0.165 + Initiation_Fee_Tax_Amount__c,5.00
)
),
0.00)
)
6 respostas
You could also do it like this
IF(
Order.CVRSOS__Job__r.CVRSOS__HourlyRate__c < 11.01,
5.00,
CASE(Order.Contract.US_Local__c,
"YES",
((Taxable_Dues_Amount__c * 0.22) + Initiation_Fee_Tax_Amount__c),
"NO",
((Taxable_Dues_Amount__c * 0.165) + Initiation_Fee_Tax_Amount__c),
0.00)
)
