How to use a calculated field to sum up table columns?

1

I have a table with the field code “hours_table”.

Inside the table, I have the following fields.

A dropdown field with the field code  “type” which can be “Travel” or “Work”

A number field with the field code “sun”

A number field with the field code “mon”

A number field with the field code “tue”

A number field with the field code “wed”

A number field with the field code “thurs”

A number field with the field code “fri”

A number field with the field code “sat”

I want to create a calculated field outside the table to sum up the hours for each day.

This is what it looks like:

Type  Sun    Mon …Fri    Sat

Travel 1        2 …3      4

Work  2        2 …1       2

Then a calculated field below the table with the formula SUM(sun) to sum up the hours for ‘sun’.

I used sum(sun), but it is showing me the error:

  • Relevant function is not used for the value of the array type. As for values of array types and their usage, refer to the help.

How to add hours vertically for each day inside or outside the table?

How to add hours horizontally for each “type” inside the table?

2

Hello annaylee,

If you would like to add hours vertically for each day inside, the equation you mentioned is correct.
I tested myself from your description, and it worked fine.
So make sure both the settings and the field codes are correct.

If you would like to add hours horizontally, you could use a calculated field at the end of the row
and use the following formula:

Sun + Mon +Tues + Wed + Thurs + Fri + Sat

SUM/CONTAINS Functions: Calculations in Tables
https://get.kintone.help/k/en/user/app_settings/form/autocalc/table_autocalc.html

I hope this helps.