Expressions in charts!

[#1]

=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?

[buzzy996 · Accepted solution]

use this,

=Avg({<[E_D Code]={'10','45'} >}Amount)

[#3]

Avg({<[E_D Code]={'10','45'} >}Amount)

should work.

basically

[E_D Code]={'10','45'} in set Analysis is OR condition.

[buzzy996]

can u mark as correct if ur happy with tht sol