nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculating Sum for Multiple Tables

khitch

Hi, I have three tables and three datasets that I want to grab values from and calculate the sum of those values onto another table.
 
I know this is done somehow using scripting but I'm unsure exactly how as I'm new to this.
 
Any help?
 
 
*edit - did the calculation in sql using select within select and sum, instead of in BIRT - it worked
problem solved

Find more posts tagged with

Comments

micajblock

BTW, in case you are curious, this can be done with either global variables or report variables. You set the variables in the onCreate of the first 3 tables and use it in the 4th table.