Total ofRunning totalShow the cumulative total for the current and all previous records. To restart the running total for each sorted group, also select Restart summary for each sorted group and select the field upon which the sort will be restarted from the field list.
Summary fields are associated with groups of records. The value in a summary field can change depending on where you place the field on a layout, how many records are in the found set, and whether the records are sorted.
By changing the formula in the calculated TotaDifference field I got SumTotalDifference to work properly. Great.
My next step was to use the 'newly accurate' SumTotalDifference field in a script. That apparently is an idea but can't be a practice.
Notice how SumTotalDifference does NOT show -205 but instead shows Dues::TotalDifference. What causes this
'strange' behavior. How can SumTotalDifference be accurate on the layout but internally show a different value?
The layout is based on Members.
The portal that holds the TotalDifference field is based on Dues
The protal resides on a Tab labeled Dues. The SumTotalDifference field is directly above the portal on the Dues Tab.
Does this help?
(I haven't gotten any suggestions so I don't feel so bad about being stumped by this one 8-)
Don't specify the running total option. Either clear this option or create a new summary field with all the same options except that the running total is not specified.
Last night I decided to see how a previous version handled the SumTotalDifference field. It turns out Dues::SumTotalDifference needed to be in the 'one' Members::SumTotalDifference.
After I moved the field, it worked great. So, it looks like the Summary field should be in the 'one' and the summarized field should be in the 'many'. That seems to make sense.. so, lesson learned.