Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

How to make input for two decimal digits?

Avatar

Level 10

HI,

Looking your input about how to make input value acceptable upto 2 decimals.

Basically, a custom field created with type currency.

Calculation field formula: 

PROD({DE:2.1 Actual Unit Savings in Euros},{DE:2.2 Actual Volume Units / Year})
 
Appreciate any recommendation.
Custom form field.jpg
1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi Kundan,

 

The number of decimal places displayed is configured in your view settings.

 

If you go to your report/view editor, click on the currency column you want to display with 2 decimal places, then click advanced options. You can update the field format accordingly. See below example. 

 

Screenshot 2023-03-07 125325.jpg

 

Best Regards,

Rich. 

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi Kundan,

 

The number of decimal places displayed is configured in your view settings.

 

If you go to your report/view editor, click on the currency column you want to display with 2 decimal places, then click advanced options. You can update the field format accordingly. See below example. 

 

Screenshot 2023-03-07 125325.jpg

 

Best Regards,

Rich. 

Avatar

Level 10

Excellent @Richard_Le_ 

Sometimes the possibility is in front of us, but we are not able to see it.