In a saved search I am pulling average cost. I want to write a condition that if that field has no value then use cost. the following formula works with either value, but I can't seem to sequence the statement to get to if 'averagecost' is blank then 'cost'.
TO_CHAR(ROUND(({averagecost}*{transaction.quantity}),2)*-1,'9999999.00')
TO_CHAR(ROUND(({cost}*{transaction.quantity}),2)*-1,'9999999.00')
Iam a newbie so any help is appreciated.