How to make data forms dynamically calculate value

Summary:

How to make data forms dynamically calculate value

Content (please ensure you mask any confidential information):

We want to exclude an account & entity combination from a parent in the data form. However, we were advised by Oracle Support that the 'exclude' function in the data form in FCCS is merely for presentation and does not dynamically calculate the overall total of the parent account & entity combo to exclude the specific account & entity combination. For example:

Parent Entity1 Entity2

Ac1 100 60 40

Ac2 50 30 20

Total 150 90 60

Say we want to exclude 40 from the overall total of 150 in the data form. Exclude function does not dynamically recalculates the overall total from 150 to 110. Currently, we have to create a separate row to retrieve the 40, and then add a calculation row to subtract the 40 from 150.