Adding two tags as a total in bip template
Hi guru's
I need a bit of assistance please. This is the xml:
I want to total tags EXTENDED_AMOUNT which lies in 3 separate G_3's.... and it's related OPENING_BALANCE which lies in G_1.
Now I know in this case the opening balance is 0, but I have others which are not 0. I want to add this at the end of the report for each customer as a total of opening balance plus movement. OH I I also need to have a way of if the total is below 0 I must pop it into the CREDIT side of the report and if it is 0 and more than 0 then I must pop it into the DEBIT side of the report.