Expand my Community achievements bar.

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.