Problem with a calculation with 3 fields (Level=Novice)

[diegushra]

Hi everybody, I can´t get a formula to solve my problem, I´ve 3 fields, "Income", "Expenses" and "Total" like in this spreadsheet https://docs.google.com/spreadsheet/...zFvcHNad0dSYXc

But i can´t get Filemaker to do the same operation.

In the first row "Income" has a value and the "Total" is "Income - Expenses", but in the second row "Total" need to subtract from the previous "Total" and then from "Expenses"

Any help?

[LaRetta]

Hi! Welcome to FM Forums!

What you require is a summary field. You first create a calculation which produces the 'total' per record maybe called cLineTotal, which in your case would be:

Income - Expenses

Then a summary as: Total of cLineTotal ... and notice the 'running total' checklist at the bottom. :laugh2:

[doughemi]

Try

Total = If(Get(RecordNumber) = 1; Income - Expenses; GetNthRecord(Total; Get(RecordNumber)-1) + Income - Expenses)

[diegushra]

What you require is a summary field.

Then a summary as: Total of cLineTotal ... and notice the 'running total' checklist at the bottom.

Great!!!! This worked like a charm!!!!

doughemi, thanks for the formula, with this I know a new way to do it!

Thank you both!!