Hi. In my opportunities, I am trying to multiply two values: a per transaction price x a quantity of prepaid transactions, to calculate the total prepaid dollar amount of a deal. I used the commission workflow as a starting point, but I’m getting an error. The workflow formula is below:
Pilot/Yr1 Annual Min Fee - change to - Use a Formula - IF(ISBLANK(prepaid_active_customer_fee), 0, (prepaid_active_customer_fee*pilot_yr1_prepaid_active_payment_customers))
When I save, I get an invalid statement error. Can anyone see what I’m missing?
@glenf, thanks for posting! It looks you like have several custom fields in your formula. When you have a custom field, you’ll need to put
cf_in front of its field key. For example:
Try that change and let me know how it goes!