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...
Forum Discussion
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.