I tipi di file classici non potranno più essere utilizzati a partire da gennaio 2021. È possibile effettuare la transizione dei file classici o scaricare un PDF. Ulteriori informazioni

Rounding Down Whole Numbers

Richiedi una demo

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

Commenti

2 commenti

Data Voti
  • 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

Accedi per aggiungere un commento.