Forum Discussion

SeanV's avatar
SeanV
New Contributor III
2 years ago

SpreadSheet and Percentile Functions

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 Spre...
Excel Add In
JackLacava's avatar
JackLacava
Honored Contributor
2 years ago

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.

  • SeanV's avatar
    SeanV
    New Contributor III
    2 years ago

    Thank you Jack,

    Any idea how I could go about confirming this?

     

     

    • JackLacava's avatar
      JackLacava
      Honored Contributor
      2 years ago

      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.