Formula for using data from 4 fields and total it in the 5th field

Hey guys,

I’m a rookie to this site and tech. I generated a dataset for my learning purpose. I want to add values from Field 1, Field 2, Field 3 and Field 4 and total it in Field 5. Can you please let me know how to do it?

Thanks a million.

You can do this by using the Formula type. If your fields are field1, field2, etc… your formula would be:

field1 + field2 + field3

If your field names have spaces, start with a capital letter, or use any other special characters, use:

field('Field 1') + field('Field 2') + field('Field 3')

A video on formulas:

Thanks for the response. I tried this formula but the problem is the data in Field 1, Field 2, Field 3, Field 4 are in decimals ex 23.89, 21.31, 44.89, 81.98. When I tried this formula
field(‘Field 1’) + field(‘Field 2’) + field(‘Field 3’) + field (‘Field 4’) to total in ‘Field 5’,
I get this below error

error: no implicit conversion of BigDecimal into String

Could you please help?

What data type are you using for Field 1, Field 2, etc…? Can you post the share link at the bottom of your schema?

Here’s a working example:

Hey guys, I tried it and it works now. Thank you so much. This site is awesome.