Sum in excel

  

Hi,


i made a tablerecordtoexcel , each row has a amount, , my question is how can i make the sum in the bottom of the last row as total after exporting to excel.


Thanks,

Tams 

RecordListToExcel is a very simple action, it just pump a recordlist to excel without complex customization.

You may need Advance Excel component in Forge to do complex operations.


However, there is a workaround.

Create a variable with same record type.

Assign GetSomething.List.Count to the first column of that variable.

Use ListAppend to append record in that variable to GetSomething aggregate

Then use RecordListToExcel.


So in essence, you will be adding/appending a new record (containing count number in the first column) to your Aggregate's List.