Remove Currency Code Prefix in Mail Merge

(0) Share

Report

Posted on by Community Member

Hi Experts,

I write mail merge for Print Quotation for Customer CRM 2016 Online. I try do a calculation to get total after minus with discount. My calculation coding is {= ({MERGEFIELD Quote_Product_Price_Per_Unit } - {MERGEFIELD Quote_Product_Manual_Discount }) }. But, when I preview result it display !Syntax Error, ,

I post my question in Microsoft Community, a few people suggest me but when I try by myself, it not work. When I try using this code ({MERGEFIELD Quote_Product_Price_Per_Unit } - {MERGEFIELD Quote_Product_Manual_Discount }) It work, but it display (RM2000.00 - RM10.00). I believe the syntax error because of 'RM' prefix. How can I remove the currency code and just take the currency value? I try use {MERGEFIELD Quote_Product _Amount \# ##0.00} It will display just 0.00 not 2000.00.

Relly hope someone can help me to solve this problem very quickly.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

There is no practical way of doing that with the mail merge.

Was this reply helpful? Yes No