03-09-2023
12:57 PM
- last edited
a week ago
by
JackLacava
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?
03-10-2023 06:06 AM
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.
03-10-2023 08:06 AM
Thank you Jack,
Any idea how I could go about confirming this?
03-10-2023 10:36 AM
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.