Rounding Error
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello all,
It would be great if someone could help me with an issue I am having to round the numbers in a column. I am using the Round formula as follows: Round([RECONSTRUCCIÓN_COSTE_2], 3). I want the formula to round the values in the column Reconstrucción_Coste_2 and only leave 3 decimal places. Is this formula correct?
The issue that I am having is that the results are not right. For example, in the first row I have the number 4.22196, which should round to 4.222. However, the formula is rounding it to 3? I don´t understand why this is. In another row, the number 6.24234 is being rounded to 6. This makes me think the formula is rounding to the nearest integer. But if this was the case, the first example would be rounded to 4 and not 3. Also as a note, the column with the numbers has Double as the data type.
Does anyone have an idea of what might be happening? Thanks so much in advance!
- Labels:
- Data Challenge
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you!!
