Rounding in Calculated Field | Community
Skip to main content
L
LisaRa2
February 21, 2020
Question

Rounding in Calculated Field

  • February 21, 2020
  • 4 replies
  • 1005 views
Hello! I have a calculated field where I am adding 3 fields and dividing by the sum of 2 others. I'd like to round the result to 2 decimal points. I added in the Round formula but it only seemed to round to the nearest whole number. What am I missing? Thanks! Lisa Lisa Ramsden Enabling Solutions
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

4 replies

T
TerryHy
Level 8
February 22, 2020
Without seeing your actual calculated field, I think you may have forgotten to add how many decimals you want to have in the ROUND equation. See sample text below. This will add 2 decimal places to your equation. ROUND(DIV(Test Field A,Test Field B) ,2) Terry Hynd EBSCO Information Services
L
LisaRa2Author
February 22, 2020
Thank you. Here is my formula: ROUND(DIV(SUM({Impact to Customer Experience?}*.30,{Impact to Employee Experience?}*.20,{Financial Benefit?}*.50),SUM({Financial Investment?}*.60,{Estimated Project Duration?}*.40),2))) I did try adding the number of decimal places, but it is still rounding to the nearest whole number. It took something that was 1.18291942 and made it 1. Appreciate the insight! Lisa Lisa Ramsden Enabling Solutions
Heather_Kulbacki
Community Advisor
Heather_KulbackiCommunity Advisor
Community Advisor
February 24, 2020
To me it looks like there's an extra right-paren and one might need to move. I'd try this: ROUND ( DIV ( SUM ( {Impact to Customer Experience?}*.30,{Impact to Employee Experience?}*.20,{Financial Benefit?}*.50 ) ,SUM ( {Financial Investment?}*.60,{Estimated Project Duration?}*.40 )) ,2 )
L
LisaRa2Author
February 24, 2020
Thank you so much!!! Now it works!! Lisa Ramsden Enabling Solutions
Terms & ConditionsAccessibility statement

Loading footer...