Grand Totals bip template

Chez

Summary

Grand Totals bip template

Content

Hi All

Need a little help please. I am sure this should be straight forward, but I just cant get this to work correctly. I Am building a template that will deliver customer aging report in excel. The columns of data are customer number, customer name, amount, and then all the 7 aging buckets.

Now I have got it working and the results I am getting is exactly correct, however I Cannot get it to total the columns! The xml is quite complicated so I will upload xml for your review.

I will also upload a screenshot of the bip template code.

Now I am only pulling data for when the sort_Filed2 < 2000 as I only want records for two of the accounts which are sort field2 = 1655 and 1077.

So I therefore only want to total for the same dataset but the command to total the first column is just not working. The results I get is 0. I need it to total to the correct amount.

Any help would be greatly appreciated.

Thanks

C

 

Version

12.2.1.4.0