The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

SeanV's avatar
SeanV
New Contributor III
3 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
Icon for OneStream Employee rankOneStream Employee
3 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
3 years ago

Thank you Jack,

Any idea how I could go about confirming this?

 

 

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    3 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.