Use the total of one table for another function in another table

Сonversation on different topics
Post Reply
laarl97
Posts: 6
Joined: Thu Feb 09, 2023 2:35 pm

Use the total of one table for another function in another table

Post by laarl97 »

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.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Use the total of one table for another function in another table

Post by Lech Kulikowski »

Hello,

Please send us a sample report with test data for analysis.

Thank you.
Post Reply