Round to the nearest thousandth point

2 followers
0
Avatar

Can someone suggest any logic or syntax to convert a number to the nearest thousandth point using Datameer functions?

For example,

Input: 186,360   Output: 186,000

Input: 37,656     Output: 38,000

Kamalkorat

2 comments

  • Avatar
    Alan Mark

    Hi Kamal,

    Create a new column where you divide the source column by 1000, and apply the ROUND function.

    Create a second new column where you multiply the first new column by 1000.

    Sincerely,

    Alan

    0
Please sign in to leave a comment.