Process explorer KPI - use a field from case table

Hi,

I have two tables in the data model - an activity and case table.

I wanted to show the sum of ‘payment amount’ on each activity of process explorer, so I can see how much value those activities represent. I have used following code but it’s not giving me the correct numbers.
SUM(“CASE Table”.“PAYMENT AMOUNT (GBP)”)

Please can you help?

Thanks,
AJ

Hi AJ,

I have no idea whether this works but did/could you also try to use a Pull Up function, like PU_SUM(case table, case table . payment amount)?

Thanks for the response joosbuijs.

I tried it and it doesn’t seem to work either.