Forum Discussion

StevenPearson's avatar
StevenPearson
Qrew Assistant Captain
3 years ago

Running Total

I can't seem to find a solution anywhere so here is my question: I have 4 fields. A, B, C, D  D is a formula field that totals A, B, &C.  I want to be able to adjust A, B or C and have the new tot...
PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
You can use something like this:

var number A = SumValues(GetRecords("{3.LTE." & [Record ID#] & "}"), fidA);
var number B = SumValues(GetRecords("{3.LTE." & [Record ID#] & "}"), fidB);
var number C = SumValues(GetRecords("{3.LTE." & [Record ID#] & "}"), fidC);

$A + $B +$C​


Replace fidA, fidB, and fidC with the field ID for your Fields A, B, and C.

One Caveat with this approach, if the table is large or has several inter app relationships, using three formula queries in one field could degrade performance.
------------------------------
Paul Peterson
------------------------------