Discussion Board for collaboration related to QlikView App Development.
i need to create a table that shows planned shipments of an item, actual shipments, and finally calculate the % accuracy.
im using the following expression to calculate the % accuracy:
(actual-planned)/actual * 100
but the output doesn't seem right, does anyone have a better idea of how i can calculate this?
SHIPMENTS or SHIPMENT?
apologies, SHIPMENT is correct
Natasha, have a look at the following link, I think it may help to a degree. Feel free to search the Design Blog area for other posts to, there are hundreds out there with more examples etc. Hopefully this may help move you along a bit further.