Formula and logic question.

Falnangel

I have a schedule that, at the end of each month, two fields will be added to this schedule with the field names starting with "Current_Month_End_Date + Amount A" and "Current Month End Date+Amount_B". Please see screen shot 1. Therefore, by the end of 2026, this file will essentially contain Amount A and Amount B fields for each of the month end within 2026.

I would like to add a calculation field at each month end that reflects Amount B minus Amount A. See screen shot 2 below. The field name for this calculated field would be "Current_Month_End_Date_Calculation". Since the data fields are being added to the original file starting with a different date each month, is there a way I can systematically add this calculation field in the logic without having to manually revise the calculation formula each month? 

jrlindem

@Falnangel  Okay, here's a mock-up of a way to do this.  Note the Multirow-Formula Tool and how I'm splitting things up between the values, the sub-totals, and the total before Union'ing them back together and Crosstab'ing.

This will scale as you add new date values to the data!

Hope this helps, -Jay

jrlindem_example.yxmd