クラシックファイルタイプは 2021 年 1 月をもって使用できなくなりました。クラシックファイルを移行することも、PDF をダウンロードすることもできます。詳細はこちら

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!

1

コメント

2件のコメント

日付 投票
  • Isabel Messore

    Hi Linda Walter,

    It depends... Is the data your working with in the ESG experience? or Is this in the spreadsheets experience?
     
     
    0
  • Linda Walter

    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

サインインしてコメントを残してください。