Skip to main content
Question

Sum of PO Amount on each activitity on the Process Explorer

  • March 8, 2021
  • 2 replies
  • 28 views
.
Level 1
Hi - I have two tables ACTIVITY_1 and CASE_1.
  • ACTIVITY_1 has different statuses of PO.
  • Case_1 has all the distinct POs and PO Amount.
Now I want to show the sum of PO Amount on each activitity on the Process Explorer. When I use a simple SUM calculation or PU_SUM calculation, it double counts the PO amount, if a PO has gone through an Acitivy/Status more than once. This is supposedly a simple calculation, but I dont seem to be able to create it yet. Can you help please?

2 replies

joos.buijs
Level 10
Forum|alt.badge.img+10
  • joos.buijs
  • Level 10
  • March 9, 2021
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?).
.
Level 1
  • .14600779
  • Author
  • Level 1
  • March 9, 2021
Hi Joosbuijs,
  1. Yes, PO has an amount in the CASE table, and there are 1 or more activities occuring per PO in the ACTIVITY table.
  2. 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
Community Code of ConductAccessibility statement