Need help in converting the data sets to "K"s and "M"s

Virali

Trying to build bar graphs with large set of data and looking for help to convert the values to K's and M's. The Dashboard has a lot of key information that I would need to represent and hence it is congested for me to write all these numeric values as data values

I sincere appreciate any help to round a number to "K"s and "M"S asap.

Paul Newcome

That would have to be done on the metrics sheet. You would take the result of whatever formula you are currently using and divide it by 1,000 or 1,000,000 accordingly.

=COUNTIFS(..............................................) / 1,000