Variabilize Expression - switch fields within expression

[#1]

Hello the community,

Is there any way to modify/switch the content of an expression by simply turning off/on one button ?

I have Budget/FCT1/FCT2 data, that I compare with actuals.

Instead of having one table showing all the columns, I want to switch my field within my expression.

=Num(Sum({$<[CPD Cost Element] -= $(v_ChargingCostElements) >}
[CPD Monthly FCT1 (Local Currency)]* CurrencyRate_2/CurrencyRate_1 ), CurrencyFormat )

or

=Num(Sum({$<[CPD Cost Element] -= $(v_ChargingCostElements) >}
[CPD Monthly FCT2 (Local Currency)]* CurrencyRate_2/CurrencyRate_1 ), CurrencyFormat ) \

or

=Num(Sum({$<[CPD Cost Element] -= $(v_ChargingCostElements) >}
[CPD Monthly Budget (Local Currency)]* CurrencyRate_2/CurrencyRate_1 ), CurrencyFormat )

I did use the "group" button for the table, it works fine, but I also have many text objects on my application, that's why I thought that switching the field of my expression using a button/switch would be better.

Any idea ?

Thank you

[maxgro · Accepted solution]

try

Dynamic Tables and Graphs

[#3]

Thank you Max

Sorry for the late answer