Question

Timevalue Formula not working

Forms

Updated March 13, 2023

asked on March 9, 2023

Hi all,

I am trying to add a couple of columns together, but am having trouble referencing them. What am I missing here. At the moment I'm jus trying to add it to 5. The Total hours (mon_shift_total) is derived from a TIMEVALUE formula, would that be a problem?

=ADD(INDEX(mon_table.mon_shift_total,ROW()),5)

0 0

Answer

SELECTED ANSWER

replied on March 10, 2023

Hi Shan,

The INDEX(column, row) returns the item from table with given row id, and in your use case, it's ROW(), however the ROW() returns the row id of the field in table it set on, but the Number field is not in any table, so the ROW() makes non sense here, you need to put the Number field in table as well. You can refer to https://doc.laserfiche.com/laserfiche.documentation/11/administration/en-us/Default.htm#../Subsystems/Forms/Content/FieldCalculations.htm how to use them.

1 0

Replies

replied on March 13, 2023

Thanks Zhiyong,

Yes that cleared that up and I got it working. Thanks for the help.

0 0

You are not allowed to follow up in this post.

Question

Question

Timevalue Formula not working

Answer

Replies

Sign in to reply to this post.