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

Question

Form Field errors using new calculator box

Updated March 23, 2016

asked on March 21, 2016

the Gain calculator is: =QUOTIENT(feed,fcr)

But when I enter a value for feed it immediately gives this error then when I enter a value for FCR it remains like this and has no changes. Am I supposed to be setting some other values in the calculator box?

0 0

Replies

replied on March 21, 2016

Actually found that the single line with doesn't work on these. I switched to number fields and it works. but is there a way to increase the accuracy?

Ex: 188/155=1 I want it to return up to 2 digits. "1.22"

0 0

replied on March 21, 2016

In Forms the Number Field will support Decimals, but it is default to 0 decimals when you drag it onto the page. Edit the Field, and near the bottom change the Decimals: Number of Decimals to 1 or 2, whatever you need and the field will then accepts decimals and extend out to what you require

0 0

replied on March 21, 2016 • Show version history

If using the QUOTIENT function, that returns only the integer component of the result of the division. You can read more about these functions in the Help Files or in the OpenFormula documentation. (Note that in the latter, not all of those functions have been implemented in Laserfiche Forms.)

For "proper" division, simply use the "/" division operator (works only with number fields).

0 0

replied on March 23, 2016

The original reason for the error was that the default value for FCR is 0 and dividing by 0 is not possible, so there will be an error until your denominator does not equal 0. In the Basic options for number fields one of the options is number of decimal places.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked March 21, 2016
Updated March 23, 2016
155 views