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

Question

Question

SUM function rounding off issue

Forms
Updated November 2, 2020
asked on November 2, 2020

I use SUM function in Forms to add 2 textbox values. If I enter 10.35 and 0, SUM shows as 10 instead of 10.35. How do I fix?

0 0

Answer

SELECTED ANSWER
replied on November 2, 2020

Hi Priya,

Before trying anything else, is your number field containing the SUM calculation configured to allow for 2 decimal places? Number fields default to 0 zero decimal places, and I'll usually forget to change that prior to doing any testing.

0 0
replied on November 2, 2020

That was it, thanks

 

Priya

0 0

Replies

replied on November 2, 2020 • Show version history

Hi Priya Ramanujam,

 

1°) Use Number Field

2°) Check if yours fields use decimal?

Then enjoy

 

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

Sign in to reply to this post.

Details
Related Posts
Loading ...