Rounding in Calculated Field | Community
Skip to main content
LisaRa2
New Participant
Feb 21, 2020 11:56 PM UTC
Question

Rounding in Calculated Field

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

LisaRa2Author
New Participant
Feb 24, 2020 4:01 PM UTC
Thank you so much!!! Now it works!! Lisa Ramsden Enabling Solutions
Translate
Heather_Kulbacki
Heather_Kulbacki
Level 2
Feb 24, 2020 3:50 PM UTC
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 )
Translate
LisaRa2Author
New Participant
Feb 22, 2020 12:26 AM UTC
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
Translate
TerryHy
Level 8
Feb 22, 2020 12:16 AM UTC
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
Translate
Terms & ConditionsAccessibility statement

Loading footer...