Help

Formula of multiplication not giving me decimal places

Solved
Jump to Solution
3291 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Emily_Cooley
6 - Interface Innovator
6 - Interface Innovator

I’m sure this is a simple solution but I am just learning the formula lingo. All in the same table, in field a, I multiplied field b by .14 and it automatically rounds the number up. As this is a dollar amount and field b is also a formula multiplying other fields, how do i get them to give me two decimal places instead of rounding all numbers up to the nearest integer. I’d love to take the extra cents but don’t think my customers would appreciate. Thanks.

1 Solution

Accepted Solutions
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @Emily_Cooley,

When you open up the Customize Field you will find there is an option for Formatting, clock on that and you will find the precision, turn in to decimals instead of integer.

BR,
Mo

See Solution in Thread

3 Replies 3
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @Emily_Cooley,

When you open up the Customize Field you will find there is an option for Formatting, clock on that and you will find the precision, turn in to decimals instead of integer.

BR,
Mo

Mo!!! How are you? I knew it was something that simple. Sometimes, the analytical mind goes “huh what”. Hope you are staying safe and healthy out there! Thanks!

My pleasure Emily :slightly_smiling_face: it happens !

All is good on my side. Hope all is good with you too