Set analysis expression

[GraceGao]

Hi Experts,

i would like to calculate amount as below ,however, no result. Can it be realized? Please help. 

sum({condition A} Quantity *avg({condition B} price))

I want to Quantity * avg (price) and get sum amount.  if i write as below the result is not expected.

sum({condition A } Quantity)*avg({condition B})

[lorenzoconforti]

Try this

sum({condition A} Quantity * $(=avg({condition B} price))  )

[dplr-rn]

agree with lorenzo.

i would put the avg expression in a variable  so that its calculated globally