Please can you help me with an expression for the following table.
I want to calculate the cost per "JobID" but only include "JobID" that contain code "VR" ( so the total for job IDs 42067, 42074, 42081)
Solved! Go to Solution.
I want to calculate the complete job cost; sum(price) with JobID as dimension would work fine,
BUT I want to include ALL codes for JobIDs that contain CODE "VR" - not just the VR code
Thanks Andrey, that looks good but I'm just getting an empty table - am I missing something?
instead going for complex expression, try creating flag in scrip
(html, codepage is 1252, embedded labels, table is @1);
LOAD distinct JobID,
1 as Flag
Now create chart with below expression