Rounding Down Whole Numbers
We have all numbers in our ESG Factbook in the fullest precision, but we need to round up or down as needed for our ESG disclosures. I understand how to display the numbers rounded up, but cannot figure out how to get them to display rounded down. For instance, we need to display the number 4,551,754 as "more than 4.5M" however I cannot find a way to round it down so that it displays this 4.5M instead of 4.6M. Currently we are showing it as "4.6M (stated as 4.5M)" but we cannot publish it that way, so we have to break the links. Do you have a suggestion for this scenario as we have a lot of ESG numbers like this. Please help ~ Thanks!
-
Hi Linda Walter,
It depends... Is the data your working with in the ESG experience? or Is this in the spreadsheets experience?0
I think both, but not sure on the terminology. The data flows from the ESG program to our Factbook spreadsheet (via formulas), then we publish the Factbook sheet to the SEC module and they use the data for the 10-K and Proxy.
0请先登录再写评论。
评论
2 条评论