Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=Avg({<[E_D Code]={'10'},[E_D Code]={'45'} >}Amount)
The above is only showing me for EDCode 45 and not EDCode 10. How do I display both?
use this,
=Avg({<[E_D Code]={'10','45'} >}Amount)
Avg({<[E_D Code]={'10','45'} >}Amount)
should work.
basically
[E_D Code]={'10','45'} in set Analysis is OR condition.
can u mark as correct if ur happy with tht sol