Skip to main content
Kundanism
Kundanism
Level 10
Mar 7, 2023 10:00 AM UTC
Solved

How to make input for two decimal digits?

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.
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Richard_Le_
Richard_Le_Accepted solution
Community Advisor
Mar 7, 2023 12:56 PM UTC

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. 

 

 

Best Regards,

Rich. 

View in thread

2 replies

Richard_Le_
Community Advisor
Richard_Le_Community AdvisorAccepted solution
Community Advisor
Mar 7, 2023 12:56 PM UTC

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. 

 

 

Best Regards,

Rich. 

Translate
    Kundanism
    KundanismAuthor
    Level 10
    Mar 8, 2023 12:48 PM UTC

    Excellent @richard_le_ 

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

    😉

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...