I have tried using
IF "{MERGEFIELD ACCOUNT_BDM_LIFE_RISK_REGION}" = "QLD" "85000" "" \* MERGEFORMAT \*
but it doesnt help much. nothing was displayed.
3 answers
I think creating a Formula Field would be much simpler and would give you a greater control too. Like as below: CASE(
ACCOUNT_BDM_LIFE_RISK_REGION__c,
'QLD', 8500,
'VIC', 2500,
NULL
)
You can then use that as the Merge Field in the template.
