Question

Formula to total number fields and radio button values

Forms

Updated May 1, 2017

asked on April 26, 2017

I am trying to create a formula to display a total of a row of fields in a table. The formula is not throwing an error but it's not reading my radio button values, only the number field types. I have assigned numeric values to the radio buttons.

Do I have to drill deeper to actually get the value of the field? If so, what's the OpenFormula syntax for that, or do I have to move this to javascript?

Thanks in advance.

0 0

Answer

SELECTED ANSWER

replied on April 27, 2017

Nevermind, I just wrote it in JS.

0 0

Replies

replied on April 27, 2017

How is your table looks like and what is the formula you are using?

I used following ones and it works well:

0 0

replied on April 27, 2017

My equation is:

=SUM(Table.score1, Table.score2, Table.score3, Table.score4, Table.score5, Table.score6, Table.score7)

and the total would only be the sum score1 + score3

2017-04-27 08_03_10-Layout _ Laserfiche Forms.png (9.24 KB)

| Download

0 0

replied on April 28, 2017

I actually do not have any issues using your formula:

How are your radio button lists configured?

1 0

replied on May 1, 2017

Hi James,

I went to create a screen cap to upload as a response to your question. Just for the "fun" of it, I ran a preview of the form, and bang, it's working now.

I have no idea why it wasn't before. Maybe something weird got cached in the browser, or LF Forms just need the weekend off.

Thanks, for your response.

0 0

You are not allowed to follow up in this post.

Question

Question

Formula to total number fields and radio button values

Answer

Replies

Sign in to reply to this post.