Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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?
you have to recalculate in the textbox
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?
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
I made it work by setting variables