"The Total field is a calculation of type Number."
It should be type calculation (with calculation result set to number within the calculation dialog). And all three fields should be defined in the related table (same table that your portal is from).
I meant that Total is of type calculation with output as number.
I found the problem. One of the fields was set to type text, not number. Once I changed it everything worked.