Sometimes, we sell multi-year subscriptions and bill monthly in arrears. To avoid anyone having to do math in the heat of a sale/negotiation, if the answer to "multi-year sub?" is "Yes", I want the value of [monthlyfee] to be [annualfee] divided by [multiyearsubmonths]. If the answer to "multi-year sub?" is "No", I want the value of [monthlyfee] to be [annualfee] divided by 12.
I tried this formula:
Switch([multiyearsub], "Yes" , Divide([annualfee] , [multiyearsubmonths]), Divide([annualfee], 12))
Which Ironclad hated. So I tried this formula:
Switch([multiyearsub], Yes, Divide([annualfee], [multiyearsubmonths]), Divide([annualfee], 12))
Which Ironclad hates just as much. So I'm using this formula:
If(Equals([multiyearsub], "Yes"), Divide([annualfee],[multiyearsubmonths]), Divide([annualfee], 12))
Which so far Ironclad approves, but we'll see if there's a bug buried in there that causes my contracts not to generate.
What am I misunderstanding about Switch()?
