Hello,
I have created a custom statement print, but I am having difficulty converting the line.charge string to a number for the values to be summed?
I can successfully remove the “£” and “,” characters i.e. £1,532.64 becomes 1532.64, but the ?number produces an error.
Without the ?number the string concatenates the values as it loops through the list.
<#if statement.lines?has_content>
<#assign linestblwsortcol = [] /> <!-- declare container for lines table with sort column -->
<#assign bal = 0 />
<#list statement.lines as tbl>
<#assign linestblwsortcol = linestblwsortcol + [tbl + {"sortcolumn":"${tbl.datecol?string('yyyy/MM/dd/')}${tbl.description}"}] /> <!-- add sort column to the lines table with value of joined Date and Description values-->
</#list>
<table style="width: 100%; margin-top: 10px;"><!-- start items --><#list linestblwsortcol?sort_by('sortcolumn') as line><#if line_index==0></#if>
<tr>
<td>${line.datecol}</td>
<td>${line.description}</td>
<td>${line.otherrefnum}</td>
<td>${line.charge}</td>
<td><#assign bal = bal + ((line.charge?replace("£",""))?replace(",",""))?number>${bal}</td>
</tr>
</#list>
</table>
Any help would be greatly appreciated.
Many thanks in advance
Kind regards
Christopher