Share
ReportHi 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 (
Answers (
3
