[Beginner]How to add two colonne ?

peuplier

I wanted to do addition of two columns, impossible, I tried with Sum, after runningsum there was good however birt add just the firsts records of each column.

An idea ?

Thx for any help

bhanley

From your question I am not sure what type of calculation you are looking to do. If I understand what you are looking for, you have a couple options.

Are you trying to add the values in two columns to create a new value on each row of the table? Something like this:

A B NEW

---

1 2 3
4 5 9

To do this, add a dynamic text element in the column that should hold the sum. Then in the expression editor that appears you can find each of the columns you want to add (A and B above) under "Available Column Bindings". Simply create an expression that adds those two columns.

If you want to create an aggregation of the columns for the table; something like this:

A B

---

1 2
4 5

---

5 7 (New Values)

If this is what you are describing, simply drag over the "Aggregation" tool (from the Quick Tools menu) onto the footer and aggregate on the appropriate column using "SUM".

Hope this helps.