Summation by Balancing Segment in BPM
Looking for a BPM function that will allow the summation (aggregate) of amounts by grouping of Balancing segment at the Distribution level as a new BigDecimal amount to use in approval rules. We want to use this function in PR and PO Approval rules.
I'm looking for a function that will allow me to do various summation based on balancing segments value at the Distribution level as a new BigDecimal amount so i can create approval conditions with.
For example, i want to add Distribution amount when Balancing segment IN (10, 19, 30) and included that amount in a condition to check if it's between 10,000$ and 50,000$.