Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a expression in a textbox which works very well with an Alternate State of [AllTheatres]
=avg(aggr(count(ProcedureCount), Weekstart))
Moving over to Set Analysis, I had expected to be able to limit the set to the Alternate State but a text box with a expression of:
=
avg( {[AllTheatres]} aggr(count(ProcedureCount), Weekstart
))
Gives completely
differenent results
Any ideas?
Regards,
Stewart
you applied state only on the avg
apply it on count as well
Genius!!