You need to sign in to do that
Don't have an account?
Harris DH
What am I doing wrong?!
Hi,
Can anyone tell me the problem with the formula below?
{!NULLVALUE(Opportunity.Total_B__c) " ", "(Opportunity.VAT_Rate__c)"}
Im using it in an email template. Basically, if the field 'Total B' is empty on my record, I do not want anything to appear. If it is not empty, I want it to display the 'VAT Rate' from the record field. Can anyone help? This is driving me a little bit crazy...
Thanks,
David
Can anyone tell me the problem with the formula below?
{!NULLVALUE(Opportunity.Total_B__c) " ", "(Opportunity.VAT_Rate__c)"}
Im using it in an email template. Basically, if the field 'Total B' is empty on my record, I do not want anything to appear. If it is not empty, I want it to display the 'VAT Rate' from the record field. Can anyone help? This is driving me a little bit crazy...
Thanks,
David
NPM
Have you tried with "" rather than " "
"" is null " " is a space
I have not done a formula for an email template but the below would work for a formula field
IF((Opportunity.Total_B__c=""),"",Opportunity.VAT_Rate__c)