Hello,
Do you know how to calculate the 50th percentile (or any percentile) in Anaplan?
Thanks!
Arnaud
Hi @arnaud.philippe , can you share what you are trying to achieve.
We have a population of 100 data points for the same line item, cost per case, and we want to calculate the 50th percentile for this population, in order to filter out the extreme values from it Basically the equivalent of the Excel formula Percentile.Exc
Hi,
This Article should help you
https://community.anaplan.com/t5/Anaplan-Platform/Creating-QUARTILE-function-within-Anaplan/td-p/89381
Thanks & Regards,
Sai Bharadwaj
We're looking to feed live or near-live Anaplan data into Claude through MCP, but our current approach — exporting CSV files via the Anaplan Bulk Export API, loading them into MySQL, and querying from there — has a significant lag (hour-long turnaround). Curious if anyone has found a faster path, whether that's through the…
The July and August releases added several useful capabilities to Anaplan AI, including the ability to create and retrieve saved views and create list import actions. It would be valuable to extend these capabilities to support the full end-to-end user story: creating a saved view and using it as the source for an import…
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.