ERROR: Calculation contains invalid syntax
ERROR: This field contains a calculation error
I am using number fields
"Use thousands delimiter" is unchecked
I'm using:
=SUM(INDEX(Time.HRS,ROW()),(INDEX(Time.KT,ROW()),(INDEX(Time.LB,ROW()),(INDEX(Time.LA,ROW()),(INDEX(Time.HL,ROW()),(INDEX(Time.LWOP,ROW()),(INDEX(Time.Other,ROW()))
Works: =SUM(INDEX(Time.HRS,ROW()))
Doesn't work: =SUM(INDEX(Time.HRS,ROW()),(INDEX(Time.KT,ROW()))
Table name: Time
Table Variables:
Date
HRS
KT
LB
LA
HL
LWOP
Other
Total (this is the sum column)
Desc (not summing this text field)
How do I remedy this calculation error?