- ACTIVITY_1 has different statuses of PO.
- Case_1 has all the distinct POs and PO Amount.
Hi - I have two tables ACTIVITY_1 and CASE_1.
Page 1 / 1
Hi AJ,
For my understanding, a PO has an amount, and 0, 1 or multiple activities occurring, right?
Second, what are you exactly looking for? If you want to show the amount of the PO the activity occurred for you dont need a SUM or PU_SUM. Im not sure what SUM youre looking for (maybe a MOVING SUM?).
Hi Joosbuijs,
- Yes, PO has an amount in the CASE table, and there are 1 or more activities occuring per PO in the ACTIVITY table.
- Im looking to have an Activity KPI on the Process Explorer which will tell the total amount of PO that has gone through each activity. E.g. a PO_001 has amout $1000 and it has 3 activities (Create, GR and Post), and another another PO_002 has amount $1500 it has 2 activities (Created and Post). I want the amount on the Process Map Activity node to be: Create = $2500 GR = $1000 Post = $2500
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.