Extract Total from a custom field in Business Goal Section | Variable Pay

[aformisano]

Dear Community,

Based on our clients requirements, we created a custom column in the Business Goal section.

This Column = Payout Percent * Target Amount, since this is how the client calculates the Bonuses.

We need though to have the Total of this calculation in the Entry section.

According to this KBA 2084135 - Managing Data, Custom Calculations / Formulas and Functions - CMP & VRP - SAP for Me

this is not feasible.

Do you have any work arounds?

All the best

[pmacgovern]

If you are familiar with custom columns at the Business Goal level, you should also be familiar with how to Aggregate them to higher levels. If you need the sum of the field at the Entry level, you need to:

1. Create a custom column at the Business Section level and set it to be an aggregate of the custom column at the Business Goal level
2. Create a custom column at the Assignment level and set it to be an aggregate of the custom column created in step 1
3. Create a custom column at the Entry level and set it to be an aggregate of the custom column created in step 2

[xavierlegarrec]

a.formisano22 I shared some examples of what Phil is explaining here: https://blogs.sap.com/2022/09/30/goals-and-accelerators-in-variable-pay/#comment-642888 when I used this to build a custom business goal capping system for a customer.

You can also check here for other ALCF rollup/aggregate examples: https://blogs.sap.com/2023/07/13/how-to-build-assignment-data-checks-at-the-summary-level-of-variabl...