Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=NUM(min({<transBUYERTYPE={ADULT}>}transBASEPRICE),'$#,###.')
=NUM(min({<transBUYERTYPE={ADULT}>}transBASEPRICE),'$#,###.')