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?
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?
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.
