How can you write a conditional expression that abbreviates large numbers such as:
1,543,128 = 1.5m
33,764 = 33.7k

When number >= 1,000,000 then divide it by 1,000,000 then format the number to 1 decimal place

When number >= 1,000 then divide it by 1,000 then format the number to 1 decimal place

When number < 1,000 then just display the number
@wharvey2433 and of course append “M” or “k” to first and second conditional
1 Like