What is the alternative for compact number function

Hi,

I tried using compact number function in a table where there are 4-5 columns of numbers. It is not working as expected, what would be the alternate function to use to display the numbers in Thousands or Millions or Billions ?

Regards,

Sneha

0 0 21