Skip to main content
Deb Peterson ha fatto una domanda in #Data Management
We have a custom object that is for class registrations. If someone drops the class, there's a 85% refund; if we cancel, there's a 100% refund. If someone transfers from a more expensive class to a less expensive class, then the refund will be some custom amount.

 

Right now the formula is an IF statement whose "then" clause is 0, making the amount 0 on save even though the field appears to be editable.  How might I rewrite that so that we can edit it for those transfer scenarios?

 

Thanks!

 

Deb
3 risposte
  1. 10 lug 2011, 12:43
    You could have a pick list on the record which says Result Type (or something) and has "Refund", "Cancel", "Transfer" then based on that field in your fomula determine what the picklist is first and then do the calculation.
0/9000