Service Amount Total is a field of type summary.
Most likely, it has been defined to compute the "total of" Service Amount.
If you place this field in the header, body, footer, or grand summary parts of your layout, it will compute and display the total of this field for your current found set of records.
If you add a sub summary part to your report layout and place this field in the sub summary part, you can get a sub total displayed.
OK. Using Service Amount Total gives me the results I would expect from using Service Amount.
I just do not understand the "why" of it - why the Service Amount field itself is not usable.
Is there any manual page/section you could point me to that I could read and possibly understand a little better?
Many thank! I really do appreciate this.
Service amount is a single value in a single record. Service Amount Total is a field that dynamically computes totals from an aggregate of this field from multiple records.
You might explore this summary report tutorial: Creating Filemaker Pro summary reports--Tutorial
Your input is much appreciated!