Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have a situation here where I Have 2 list boxes A and B in State1 and Same list boxes in State2.
I need to retrieve the Maximum value of the B when i select in List box A in State 1 and Similarly for the State 2.
and I want them to show it in a Textbox like below.
Thanks,
Walter
May be this:
Max value of B in State1 -> Max({[State1]}B)
Max value of B in State2 -> Max({[State2]}B)
= 'The maximum value of ' & Only({State1} A) & ' is ' & Max({State1} B) &
' and the maximum value of ' & Only({State2} A) & ' is ' & Max({State2} B)
In general, the aggregations are just done like in default state, with alternate states added as set identifier in set analysis.