Unable to compute difference between 2 columns of different data sets in RTF

Question

Hello All, I have 2 fields in my RTF which are the difference values from XML: * ORIGINAL_QTY(G_1)-SUM_SHIP_LBS(G_2) * ORDER_AMOUNT(G_2)-SUM_SHIP_AMT(G_2) The section of XML looks like this: RTF section: The formulae used for difference is * * Difference is not being calculated. The preview shows the (SUM_SHIP_AMT) and (SUM_SHIP_LBS) values instead of difference. Sample data output: Any ideas on this regard is greatly appreciated!! NOTE: Any code change is not possible as it's a standard report, can only play around with template. Thanks!!

Sneha Pyapili · Answer

Thanks Saina but it didn't resolve the issue. It shows character value:

Saina · Answer

Can you try using  <?xdofx: ( (ORDER_AMT) +(SUM_SHIP_AMT(*-1)))?>