Posibility of using a caculated value(of a table) directly in another chart?

[#1]

I made a table with a few calculated columns by using complex expressions. Then I have a total of each calculated column. I want to display these totals in a textbox, do I need to recalculate them in the textbox (which would be extremely complicated to do), do can I refer those numbers directly in the textbox??

Or is it possible to call a calculated field? like using the expressions Sum(Potentiel€) in my case?

Thank you all very much!

[maxgro]

you have to recalculate in the textbox

[NickHoff · Accepted solution]

You could create a variable (press control+alt + v) for your complicated expression then call your variable in the text box = $(vVariableName).  Although, what is the issue with using your expression in the text box?

[veidlburkhard]

Hi yunatao,

Please enter this into your textbox:

Num(Sum(Aggr(YourExpressionforPotentiel€, [Type de frais])), '# ##0'). This gives your the totals in your textbox.

where YourExpressionforPotentiel€ is the expression for calculating the values of Potentiel€ in your table.

Hope this helps

Burkhard

[#5]

I made it work by setting variables