How to sum a calculation column in RTF Template
Hi
I have an amount column with positive values like 100, 200, 300
I have converted some of these amounts to negative based on a condition <?xdofx:if TRANSACTION_TYPE = 'INVOICE' then AMOUNT*-1 else AMOUNT end if?> , so the values are -100, -200, 300
Now I want to sum the calculation column, Is there a way to do it? Expected sum is -100-200+300 = 0. If I sum using the original amount column, I would get 100+200+300 = 600 which is wrong. Is there a way to sum the calculation column.
Thanks in advance
Navaneeth
I have an amount column with positive values like 100, 200, 300
I have converted some of these amounts to negative based on a condition <?xdofx:if TRANSACTION_TYPE = 'INVOICE' then AMOUNT*-1 else AMOUNT end if?> , so the values are -100, -200, 300
Now I want to sum the calculation column, Is there a way to do it? Expected sum is -100-200+300 = 0. If I sum using the original amount column, I would get 100+200+300 = 600 which is wrong. Is there a way to sum the calculation column.
Thanks in advance
Navaneeth
0