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