Skip to main content
Topics#Data ManagementDeb Peterson의 질문
Deb Peterson 님이 #Data Management에 질문했습니다
2011년 7월 10일 오전 3:22

I have a $ field, with a formula, that I'd like to be editable. Any hope?

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개
  1. Francis Pindar (AdminToArchitect.com / NetStronghold)
    2011년 7월 10일 오후 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