Skip to main content
S
SeanV
Contributor
March 9, 2023

SpreadSheet and Percentile Functions

  • March 9, 2023
  • 1 reply
  • 0 views

In Microsoft Excel, the Percentile and Percentile.Inclusive functions use the R-7 Methodology, Percentile.Exc uses the R-6 Methodology for Quantiles.

 

These functions exist in the OneStream Spreadsheet tool, does anyone know if they are the same as Excel?

    1 reply

    J
    OneStream Employee
    JackLacavaOneStream Employee
    OneStream Employee
    March 10, 2023

    The Spreadsheet tool tries very hard to behave like Excel where functions are concerned, so I would assume they are indeed the same. Any function not starting with XF should be like their Excel equivalent.

    S
    SeanVAuthor
    Contributor
    March 10, 2023

    Thank you Jack,

    Any idea how I could go about confirming this?

     

     

    J
    OneStream Employee
    JackLacavaOneStream Employee
    OneStream Employee
    March 10, 2023

    Er, by trying it? 😅 Create a sheet in excel using the functions, upload it to OneStream, then open it in Spreadsheet. Numbers should stay the same.

      Terms & ConditionsAccessibility statement