Sum of Current group in rtf template giving wrong calculation
Hi All,
I created rtf template. line amount column is calculated as,
<?sum(current-group()/C_TAXABLE_ACCOUNTED_AMOUNT[.!=''])+ sum(current-group()/C_SG_INHOUSE_INV_AMOUNT[.!=''])?> . It is giving correct output for all invoices except one.
In XML file, C_TAXABLE_ACCOUNTED_AMOUNT value is 1800 and C_SG_INHOUSE_INV_AMOUNT is -200, so ideally it should come total 1600. But sum is coming wrong. I individually placed sum in column but C_TAXABLE_ACCOUNTED_AMOUNT value in XML and excel output showing complete different values.
Kindly help.
Thanks,
Prashant