Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with Alternate States

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.

Capture1.JPG

Thanks,

Walter

2 Replies
sunny_talwar

May be this:

Max value of B in State1 -> Max({[State1]}B)

Max value of B in State2 -> Max({[State2]}B)

swuehl
MVP
MVP

= '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.