You are viewing limited content. For full access, please sign in.

Question

Question

Perform calculation on columns in table and output it to single line outside the table

asked on February 5, 2018

Hello,

This may be answered in another Answers post, but I'm having some trouble finding the right keywords to search with. What I'm trying to do is take a column from table that records minutes spent working on a repair, and no matter how many rows are added to the table, I want it to add every value in the minutes column and output it to a single line field outside the table. My calculation in the single line field outside the table is below:

=SUM(In_House_Repair_Hours.Time)

In_House_Repair_Hours is the name of the table I'm referencing, and Time is the column. Is it possible to do this without Javascript?

 

Any help is appreciated. Thanks!
 

0 0

Answer

SELECTED ANSWER
replied on February 5, 2018

That calculation should work as long as the "time" column field and field outside the table are number fields. Otherwise you'll have to use JS or a VALUE function.

0 0
replied on February 5, 2018

Ah, I didn't have them set as Number fields. Thanks!

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.