Skip to main content
D
DrSchoen
Participating Frequently
May 27, 2021
Answered

Simple formula creates trailing zeros

  • May 27, 2021
  • 1 reply
  • 1584 views

I've created a simple formula for an order form. When I enter an even-numbered quantity the result is correct, but when I enter an odd-numbered quantity the result adds innumerable extra zeros!

 

(Qty2*13.47)

This topic has been closed for replies.
Correct answer Nesa Nurani

Format field with 2 decimals.

In field properties under ' format' tab select 'Number' and how much decimal places you wish. You can also select currency sign there.

1 reply

Nesa Nurani
Community Expert
Nesa NuraniCommunity ExpertCorrect answer
Community Expert
May 27, 2021

Format field with 2 decimals.

In field properties under ' format' tab select 'Number' and how much decimal places you wish. You can also select currency sign there.

D
DrSchoenAuthor
Participating Frequently
May 27, 2021

Thank you so much!

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices