I have three columns in the same table that store three separate numeric values.
Column One is called- “John”
Column Two is called- “Bill”
Column Three is called- “Ed”
I would like to add a fourth column that adds (for each row) the values contained in “John”, “Bill” and “Ed”
I am using this formula for the fourth column-
sum(field(‘John’)+field(‘Bill’)+field(‘Ed’))
The fourth column isn’t displaying data consistently. What am I doing wrong?