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; } } }

Subtract two aggregates from two different tables(two different datasets)

Louis Walkenshaw

Hi forum,
I am currently designing a report in eclipse(birt,Eclipse BIRT Designer Version 4.4.2.v201410272105) but i am faced with a challenge, I have two tables in a grid and i need to subtract their totals from one another, I have tried global variables but they do not seem to work in the onCreate script of my aggregate.
I have tried checking other forums for similar issues but I cannot seem to find a solution, any help will be greatly appreciated.
 
Kind Regards
Louis

Find more posts tagged with

Comments

jfranken

Hi Louis,
 
One option is to create a joint data set containing both of the data sets. Go to the "Binding" tab for the grid and choose the joint data set. All of the data will be available in the grid and you will be able to create an aggregate based on data from both tables.
 
Regards,
Jeff

micajblock

or use variables. See attached example.