0

Table Builder (Formatting Decimals)

Nathan

July 12, 2018 11:57

None

Follow

In the following formula that is used in my Table Builder setup; the result will come out as 5 or 6 decimal places. The idea would be to have it at least 3 decimal places to keep it manageable. I know of the NP("Format") function but I am not sure if this is what I would want to use or not.

 

=NL("LinkSum";"2067184 Goods Registration Task Line";"407 Total Volume")

 

Please advise as to how I can turn this into a formula that would give me a round number to 3 decimal places. It would be much appreciated. Thanks in advance!!

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Harry Lewis July 16, 2018 14:08

  Hello Nathan -

  Here is an example based on a division calculation that results in several places past the decimal point:

  =NP("Formula","INT(([@[Amount]]/[@[Dimension Set ID]])*1000)/1000")

   

  

  Edited by Harry Lewis July 16, 2018 14:09