Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm having trouble figuring out how to write this as set analysis in an expression:
=AVE( [Cost of Car]/[Price of Car])
Where....
[Cost of Car] is >0
AND
[Price of Car} is not NULL
I'm trying to get to the average (percent) of cost divided by price - where the cost is greater than $0, and the field that contains the price is not empty.
Any ideas? Thanks.
avg({<[Cost of Car]={">0"},[Price of Car]={'*'}>} [Cost of Car]/[Price of Car])
avg({<[Cost of Car]={">0"},[Price of Car]={'*'}>} [Cost of Car]/[Price of Car])
Or this:
=Avg({<[Cost of Car]={">0"}, [Price of Car] = {"=Len(Trim([Price of Car])) > 0"}>}[Cost of Car]/[Price of Car])
Thanks; I had that but wasn't getting the right answer. Turns out I had duplicate VINs where both cars had a price, but only one had a cost which was giving me an answer that was half of what it should have been.