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

#1

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.

#2

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')
#3

A video on formulas:

#4

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?

#5

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:

#6

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