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

Sneha Pyapili

Hello All,

I have 2 fields in my RTF which are the difference values from XML:

1. ORIGINAL_QTY(G_1)-SUM_SHIP_LBS(G_2)
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

1. <?xdofx:ORDER_AMT - SUM_SHIP_AMT?>
2. <?xdofx:ORIGINAL_QTY - SUM_SHIP_LBS?>

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!!

Saina

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

Sneha Pyapili

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