Hi everyone,
I'm trying to create a Formula (text) for {inventorydetail.inventorynumber} so that when it is true then round({costestimate}/{quantity}. If there is no number, leave blank.
This doesn't seem to work ?
case when {inventorydetail.inventorynumber} is true then round({costestimate}/{quantity}/1.39062717,2) else null end
Thanks,
Daniel