Page 1 of 1

Column Sum

Posted: Wed Feb 13, 2013 12:22 pm
by bsilence
Hello,

I have a business object (BO) binded to a databand. This BO is a collection of data, so it will produce n-lines in this databand.
Inside this BO exists another collection, that is binded to another databand that has as master the previous databand, so that each row of the first collection has a collection of each second collection, all clear so far?
Now, on each second collection, i have a column that a want to sum into a total, how can i make this...

Element 1
Son 1 Value
Son 2 Value
Total

Element 2
Son 1 Value
Son 2 Value
Son 3 Value
Total

Element 3
.....

Can you help on this? thank you

Re: Column Sum

Posted: Wed Feb 13, 2013 1:25 pm
by Alex K.
Hello,

You can use the the Totals.Sum() function.

Thank you.

Re: Column Sum

Posted: Wed Feb 13, 2013 2:19 pm
by bsilence
Thank you for your reply, i got the answer.
To have the Total in the example above, we have to put a footerband after each "son collection" with the sum expression, like, {Sum("Your Data from wich you want to get the sum","BusinessObject.Your field to calculate")}.

Thank you for your time.

Re: Column Sum

Posted: Thu Feb 14, 2013 7:40 am
by Alex K.
Hello,

Let us know if you need any additional help.

Thank you.