Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 3 Multi boxes which are in 3 different alternate states.
I have a Straight table where i am calculating sum(Sales) and also Sum(Sales) for 3 different Alternate States.
I want to show Alternate states Expressions columns Sum({State 1}Sales), Sum({State 2}Sales) and Sum({State 3}Sales) only, when there is a selection from respective Multi boxes which are in 3 different alternate states. otherwise i want to show only expression Sum(Sales).
Please find the attached Application.
Thanks in Advance.
Is this what you are looking for?
Is this what you are looking for?
Hi Andrey,
Thanks for your help, this is what i am looking for.
But a small doubt, in the conditional expression that you have given :
If(GetSelectedCount([Product Category], ';','STATE_1')+GetSelectedCount([Product Description], ';','STATE_1')+GetSelectedCount([Product Group], ';','STATE_1') > 0, 1, 0),
in the second parameter for GetSelectedCount, we need to pass either True/False, why did you passed ';' ?
Thanks in Advance.
To be honest, I didn’t pay much attention to this parameter, I just used a line from some comment. But given that a non-numeric value gives false, it can be replaced with false(). Though in this case it may be better to use truth.