I am trying to apply sum function in my report template for a column which contains formatted number (for example *1,999.00*). It is working absolutely fine until the number is less than *1,000*. I had tried with replace function to replace comma with null and tried to make the sum, but its showing me zero in the result.
I am using *<?xdofx:sum(replace(NONRECOVERABLE_TAX,',',''))?>*
Please help me in sorting out this issue.
I need to obtain a result like
I want a result something similar like this using xml tags,