Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
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:
=FABS(sum({<[PLANNED_OR_ACTUAL]={'PLANNED'}>}SHIPMENTS)-sum({<[PLANNED_OR_ACTUAL]={'ACTUAL'}>}SHIPMENT))
/sum({<[PLANNED_OR_ACTUAL]={'ACTUAL'}>}SHIPMENT)*100
(actual-planned)/actual * 100
but the output doesn't seem right, does anyone have a better idea of how i can calculate this?
TIA
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.
https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578
Regards,
Brett