Hello,
I am wondering how I can do the following:
I have an entity that contains a lot of fee type fields (there is 1 fee type field in each of the 8 sections that I have on the form). When the Fee Types equal the same then populate the Total Administrative Fee field with the Fee amount from each fee section. Here is an example:
When the Color Black Fee Type is Black and fee amount is 10.00, and the Color Blue Fee Type is Black and fee amount is 5.00, then add the Fee Amounts together and put the total in the Total Administrative Fee field.
If there are 5 sections that have the Fee Type filled in and only 3 out of the 5 are the same, then the Total Administrative Fee field wouldn’t add up anything, but would still allow the user to put a value in the field.
All fee types that are filled in must match in order to do the calculation
I wasn't sure if I just had to do logic on every scenario possible or if there was an easier way to look for the matches?
Thank you.
*This post is locked for comments
I have the same question (0)
