1. Extensions
  2. Google Sheets Add-on
  3. Work with Anaplan model data in Google Sheets
  4. Precision differences

You can enter values with up to 17 decimal places in Anaplan. Google Sheets supports values up to 15 decimal places. 

This can cause a Google Sheets value to be detected as a value change when you perform a Send and refresh.

When your connection includes a value with 17 decimal places, the 15th decimal digit may be rounded up when displayed in Google Sheets.  This happens when the 16th decimal digit is five or greater.

If you want the 15th digit to be the same in Google Sheets and Anaplan, you can re-enter the value in Google Sheets. Google Sheets does not round the 15th digit up or down; it simply displays the first 15 decimal digits you enter.

Even if the values are the same in Google Sheets and Anaplan to 15 decimal places, if the value in Anaplan has 16 or 17 decimal places, this is detected as a value change.

Precision differences between Google Sheet and Anaplan may be complicated by floating-point math. The method Anaplan uses to calculate floating-point math may mean that the digit in the 17th decimal place is rounded up or down when entered.

For example:

  1. Enter 0.12345678901234567 into a cell in Anaplan.
    The value displays in Anaplan as 0.12345678901234566 (due to floating point math, the 17th digit rounds down to six).
  2. Connect a Google worksheet to a module containing the cell.
    The value of the cell in Google Sheets is 0.123456789012346 (the 15th digit is rounded from five to six).
  3. Re-enter the value in Google Sheets to 17 decimal places.
    Google Sheets accepts the number as 0.123456789012345 (the 15th digit is not rounded up).
  4. Send and refresh the connection.
    Send and refresh detects a value change, as the value in Anaplan has 17 decimal places (0.12345678901234566), while the value in Google Sheets has only 15 (0.123456789012345).
  5. Either:
  • Click Submit to submit the shorter value to Anaplan.
    The value in Anaplan updates to 0.123456789012345.
  • Click Refresh all data.
    The value in Google Sheets updates to 0.123456789012346.