Round to the nearest thousandth point

Follow

Kamalkorat

• October 18, 2018 19:45

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

0

• 

  Alan

  • October 18, 2018 20:59
  • Edited

  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

  Comment actions Permalink
• 

  Kamalkorat

  • October 18, 2018 20:41

  Thanks Mark for your quick response.

  0

  Comment actions Permalink

Please sign in to leave a comment.