I need to calculate rating for custom field having datatype Formula,It's value depend on three other field values and need to calculate value on the basis of rule. For this I need Temporary variables in formulas. We have Professional Edition of salesforce so can't use Apex trigger to calculate this value.

Can anyone please suggest me solution for this.

  • It would be great if you can provide the actual requirement and the fields referenced and what is the final output you are expecting. This will help us know if it is possible to do with formula else what's the possible workaround. Thanks. Nov 19 '15 at 9:20
  • The only "temporary variable" available is another formula field. That can help make the formulas easier to understand but doesn't help with the overall size limit if that is your problem. You might find something useful in Tips for Reducing Formula Size.
    – Keith C
    Nov 19 '15 at 9:31
  • Hello Keith, Thanks for reply. It's helpful I solved my problem.
    – Nayana
    Nov 19 '15 at 11:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.