Variance based on selected option in Group

[#1]

Hi

I have three columns, Actual, Budget, and Variance

The variance is:

1) Actual-Budget  and Actual-Budget/Budget

These two variance are grouped together (toggle) to switch between value and percentage (%).

I want to add in a fourth column called Forecast. I want to group Forecast with Budget

So in essence, my columns would be Actual, Budget/Forecast and Variance.

My requirement is for the Variance column to calculate based on which is chosen between Budget and Forecast.

Is this possible?

Any help would be appreciated.

Regards,

Magen

[Gysbert_Wassenaar]

These two variance are grouped together (toggle)

If that's done with an expression group then I don't think it's possible. I'd use separate expressions and the conditional display option of the expressions to show/hide the required columns as needed. A button or text object could be used to toggle between the two options using a Set Variable action and a variable. If you create a variable vToggle and give it the initial value 0 then the Set Variable action should set the vToggle variable to the value =NOT vToggle. Likewise the conditional display expressions are either =vToggle or =NOT vToggle.