Set Analysis

evansabres — Mon, 07 Nov 2016 19:22:33 GMT

Trying to rap my head around set analysis, but can't seem to get the syntax right.

Attempting to build an expression, that gives me the 'transBASEPRICE' for the 'transBUYERTYPE' of 'ADULT.'

=Round(Avg({<transBUYERTYPE={ADULT}>}transBASEPRICE),'$#,###.') is what I have but no results seem to be produced. Do I have this backwards?

Re: Set Analysis

kaushiknsolanki — Mon, 07 Nov 2016 19:28:10 GMT

Hi,

Try this.

Round(Avg({<transBUYERTYPE={"ADULT"}>}transBASEPRICE),'$#,###')

Regards,

Kaushik Solanki