Using Expressions from Table1 in Table2

[#1]

Hello!

I have the following two tables:

Table 1:

Quantities (#)	Total Sent	Anomaly	No Anomaly	Completed	Pending
Zone A	100	30	60	90 =30+60	10 =100-90
Zone B	50	10	25	35 =10+25	15 =50-35

Table 2:

Quantities (%)	Total Sent	Anomaly	No Anomaly	Completed	Pending
Zone A	100	33% =30/90*100	67% =60/90*100	90% =90/100*100	10% =100%-90%
Zone B	50	29% =10/35*100	71% =25/35*100	70% =35/50*100	30% =100%-70%

Is there any way to use in table 2 results from expressions calculated in table 1?

In order to not calculate the same thing both times... Or it is not possible to do that?

Maybe if I create a single table with all the data, it would be easier?

What do you recommend?

Thank you!!!

[its_anandrjs]

Use expressions for this in the table2

Eg:-

Let vAnomaly = Expression for Anomaly from table1

Let vNoAnomaly = Expression for No anomaly table1

Let vCompleted = Expression for Completed table1

Table2 Calculation

Anomaly = $(vAnomaly)/90*100

No Anomaly = $(vNoAnomaly)/$(vCompleted)*100

Other like the same.

[#3]

Hi,

It will be good if you create single table and after that calculations, I think in single table calculations will get fast and reduce the reload time also.

[PradeepReddy · Accepted solution]

Hi,

It is better and easy to create a single table, instead of 2 tables. By doing this we can reduce one object in our report.
So that the perfprmance will be improved.

[jagan]

Hi,

The expressions used in one chart (table) is not possible to use in another charts.  You can do this in script and use the new calculated columns in the front end.

Regards,

Jagan.

[sasikanth]

Hi mart

use single table instead of two tables , you can calculate remainin exp based on previous columns

or else

use variables i,e create variables and store these exp into variables ,

then you can call it where ever you want , this is also good, reusing exp .

Regards

sasi