Issue with using SUM & DECODE together in etext template while generating payment format outputs
I am trying to use Sum & Decode functions in etext template as follows
SUM(DECODE(DocumentPayableLine/LineType/Code,‘ITEM’,0, DocumentPayableLine/ LineGrossAmount/Value)) |
0