Using the result value from one table in another table

[#1]

Hi all, thank you for your help.

Here is another question.

I have an expression named 'Formulae' with some complex calculations in straight table.

is there any way to use its value (actually, I need sum(Formulae)) in another table or I should recalculate it?

Thank you.

[Miguel_Angel_Baeyens]

Hello,

In that case you may set your expressions as variables in your load script, so you can reference them later on. For example:

SET vFormulae = Sum(Amount);

And then use

$(vFormulae)

as expression in your charts.

[#3]

Thank you but this is not my case

Again,

I have a straight table, some expressions are coming from SQL, some are calculated.

All formulas below are simplified.

ColumnA=Date (from SQL)

ColumnB=InOutFunds (From SQL)

ColumnC=below(Date)-Date (calculated expression)

ColumnD=ColumnB+above(ColumnD) (calculated expression)

ColumnE=ColumnD*ColumnC/365 (calculated expression)

Date	InOutFunds	Term	Investments	ColumnE
01.01.2005	100	31	100	8.49
01.02.2005	120	15	220	9.04
16.02.2005	75	10	295	29.5

The sum of ColumnE counts in Total of the table and this value I want to use in another table.

[Miguel_Angel_Baeyens]

Hi,

So if I understand you correctly, there is no other way to pass one expression into another chart. You will need then to recalculate in your new chart.

Well, maybe using macros you will get it...