Set Analysis

[evansabres]

I have an expression, =NUM(min(transBASEPRICE),'$#,###.') that I would like to include another variable to. I want to know the 'transBASEPRICE' when the 'transBUYERTYPE' is ADULT.

What would the correct syntax be for that.

Thank you.

[Nicole-Smith · Accepted solution]

=NUM(min({<transBUYERTYPE={ADULT}>}transBASEPRICE),'$#,###.')