Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm working with two alternate states,
I need to make common selections on several fields, so I want to synchronize these two states.
the following syntax works to synchronize a state with the default one ($) :
count({State1<Year = $::Year, Month = $::Month>} DISTINCT [Invoice Number])
But is it possible to synchronize two states (without impacting the $ one) ?
Best regards
Hi,
Then try with this
count({State1<Year =P({State2} Year), Month = P({State2} Month )>} DISTINCT [Invoice Number])
Or
you can go with this
count({State1<Year =State2::Year, Month = State2::Month>} DISTINCT [Invoice Number])
Hope it helps
Celambarasan
Hi,
You can do it by using following expression
count({[Alternate State1]+[Alternate state2]} DISTINCT [Invoice Number])
Here + is union operation between 2 states it takes .if u need the common between 2 then use ( * ) instead of ( + )
Hope it helps
Celambarasan
Thanks for your answer,
but my problem is more specific :
I need to synchronize selections upon 5 fields between the 2 alternate states, but other fields have to stay independant.
Best regards
Hi,
Then try with this
count({State1<Year =P({State2} Year), Month = P({State2} Month )>} DISTINCT [Invoice Number])
Or
you can go with this
count({State1<Year =State2::Year, Month = State2::Month>} DISTINCT [Invoice Number])
Hope it helps
Celambarasan