I have used Filemaker since the 1980's. I am building a data base that will have pretty close to 100,000 records when done, That's NOT the problem, the problem is that I've numeric fields 1 to 25 that are not being nice and adding for a total. I have tried this with =sum(feild1 + feild2 ....+ fe…

What happens if you export just those fields to a new FileMaker file, for just one record, and you add your calculation in there? Could you upload that file here?

I will see if I can up load a sample file and record. Right now I am fighting ... like ... three irregularities with the project. Started with what seemed to be the easiest of them. Will be back later with the file. Peter Kelley St. Paul, MN USA

screen shots would help too BTW: sum ( f1 + f2 + ... +f25 ) is not a valid expression and should prompt: "A function parameter contains an expression where a field is required."

Hi @MstrPBK , Your SUM function should be using semicolons as a separator between the fields. Using plus symbols is the manual way of adding field data, no need for the SUM function if you do that.

[image] Malcolm: Your SUM function should be using semicolons as a separator between the fields. Using plus symbols is the manual way of adding field data, no need for the SUM function if you do that. Malcom has it. You would either do this: MySummationField = Sum(TableA::Field1 ; TableA::…

Also, whenever you see a database design that has 25 fields in a single table (Field1, Field 2... Field25). you are almost surely using a poor design. You probably should have these 25 fields in a related table See Database normalization - Wikipedia When you normalize the database, then your Sum…

Basic question that needs to be asked - Are all of the fields you wish to add formatted as NUMBER fields? If they are formatted as text, use the GetAsNumber() function to convert the content of the fields to numeric format. https://help.claris.com/en/pro-help/content/getasnumber.html

Welcome to Thesoup @pacerprint !

FM 17 not adding correctly ... or I am insane

Questions

Topic		Replies	Views
SQL With Calculated Fields? Questions	22	1531	November 3, 2021
Similar to Sumif filemaker	6	83	December 22, 2025
Normalisation Lounge (Discussions) fields-per-table , sql-architecture , filemaker-architecture , table-width	7	317	November 20, 2021
How many fields is too many? Questions	17	386	June 17, 2021
Radio button sum calculation Questions scripting	15	552	February 5, 2022

FM 17 not adding correctly ... or I am insane

Related topics