I have issue with formatting this field. I want to display it formatted in email template subject, therefore I cannot use the regular usage in visualforce like:

<apex:outputText value="{0, number, ###,###,###,##0.00}">
    <apex:param value="{!Quote.GrandTotal}" />

I tried as alternative solution to create formula field in Quote that will hold the formatted value, but when creating formula seems this field is not available.

Does anyone have other idea for implementing this or why I cannot use the GrandTotal field in formula? The only idea I can see now is creating regular field and populate it with code...

  • This is not related to FLS
    – Liron C
    Jul 2 '17 at 17:15
  • I have faced similar situation earlier, no formula fields are supported in Subject (not even Grand Total). For testing purpose, create a formula text and try to show the quote's name, it will not work Jul 2 '17 at 17:21

Formula field doesn't support in Subject of Email template.

So better to create Currency field and update this currency field through the trigger.

And, finally use the currency field on the Subject of Email template.

  • I'll try further to find another solution, and if will run out of option I'll do this approach. Thanks.
    – Liron C
    Jul 2 '17 at 17:29

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.