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
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 Spreadsheet tool, does anyone know if they are the same as Excel?
3 Replies
- JackLacava
OneStream Employee
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.
Thank you Jack,
Any idea how I could go about confirming this?
- JackLacava
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.
