incorrect data type for operation or @ function:number expected

[blumn]

Trying to total hours for sat-sun
fields are ap1 ap2 ap3 ap4 ap5 ap6 ap7 with default value of 0
The total field has a formula of @Sum(ap1;ap2;ap3;ap4;ap5;ap6;ap7)
When trying to create form get error message "incorrect data type for operation or @ function:number expected.


--------------------------------------------------------------------------------

 

[missjane]

When you set the default value of the field to 0 did you type it in as 0 or "0"? You need to make sure it is typed as 0 otherwise it is classed as text and this would be why the error is showing.