Use the total of one table for another function in another table
Posted: Tue Feb 21, 2023 8:26 am
Hi, me again. I finally manage to get the totals in two of my tables. But now I need the total of one table to calculate the percentage for another one.
My total on Table8 was calculated using the next:
{Sum(DProMatrixAnalysisGroups.Insulated_Glass_unit)+Sum(DProMatrixAnalysisGroups.Pine_Wood)} = 41
Now I need that calculated value to use it as a divider in another table.
I tried to do it in the next way following the function Divide {Div(DataSource.Column1,DataSource.Column2,DataSource.Column3)}
{Div(DProMatrixAnalysisGroups.Packaging_wood, Table8.Table8_Cell38)}
I've tried different variations, but it throws an empty cell. I've also tried to do it like in Excel just using the '/' but it only throws a fraction = 10/41 - the value of each.
I am having a hard time figuring out how to do it. The manuals are very confusing and usually do not present this type of cases.
My total on Table8 was calculated using the next:
{Sum(DProMatrixAnalysisGroups.Insulated_Glass_unit)+Sum(DProMatrixAnalysisGroups.Pine_Wood)} = 41
Now I need that calculated value to use it as a divider in another table.
I tried to do it in the next way following the function Divide {Div(DataSource.Column1,DataSource.Column2,DataSource.Column3)}
{Div(DProMatrixAnalysisGroups.Packaging_wood, Table8.Table8_Cell38)}
I've tried different variations, but it throws an empty cell. I've also tried to do it like in Excel just using the '/' but it only throws a fraction = 10/41 - the value of each.
I am having a hard time figuring out how to do it. The manuals are very confusing and usually do not present this type of cases.