Using data comparision with set analysis within a nested IF

[triciagdaly]

Please see attachment.

I have a nested IF and will first check for override price.  If null, check to see if a purchase price exists where the last purchase price date < a benchmark date field.  If this is null, then use receipt price.

I am having syntax issues with the If regarding the purchase price.

[swuehl]

You can only use set expression in an aggregation function like sum(), count(), only() etc.

It looks like in your expression,

IsNull(CURRENT_PURCHASE_PRICE({<LAST_PURCH_PRICE_TRAN={"<=$(=date(vBenchmarkDate))"}>} ))

it's not valid syntax. Maybe you want something like

IsNull(only({<LAST_PURCH_PRICE_TRAN={"<=$(=date(vBenchmarkDate))"}>} CURRENT_PURCHASE_PRICE))