nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using Excel function in Anaplan

SuryaKrishna228

Hi,

My question is

There is a Function in Excel and there is no similar kind for function in Anaplan, so how to in cooperate that function in Anaplan

Regards

Surya

Accepted answers

TimWard70

Apologies NORMINV uses differential calculus and mine is too rusty to give you a solution.

If you have someone who is good at calculus and can break down the below into simple calculations (A x B, A^B, log(a) etc) then I'm sure we can build it.

Normal inverse cumulative distribution function - MATLAB norminv - MathWorks United Kingdom

The norminv function uses the inverse complementary error function erfcinv. The relationship between norminv and erfcinv is

norminv(p)=−√2 erfcinv(2p)

The inverse complementary error function erfcinv(x) is defined as erfcinv(erfc(x))=x, and the complementary error function erfc(x) is defined as

erfc(x)=1−erf(x)=2√π∫∞xe−t2dt.

All comments

priyanka1029

Hey @SuryaKrishna228

Can you please elaborate what exactly you are trying to achieve.

Thanks,

Priyanka

SuryaKrishna228

Hi @priyanka1029

Like we have a function in a Excel and we don't have type of function in Anaplan, so how to use that excel function in Anaplan

Thanks,

Surya

TimWard70

Most excel calculations can be replicated in Anaplan, however, you will often need to understand the calculation behind the excel function or if not, then exactly what the result needs to be and then build out a calculation in Anaplan.

If you can be specific on what you are trying to achieve then I am sure you will be helped to find a solution.

SuryaKrishna228

Can you tell how do we build it in Anaplan

TimWard70

Possibly, but you need to tell us which function you want to replicate first.

SuryaKrishna228

Sorry for that

I want to build NORMINV Excel function in the Anaplan

TimWard70

Apologies NORMINV uses differential calculus and mine is too rusty to give you a solution.

If you have someone who is good at calculus and can break down the below into simple calculations (A x B, A^B, log(a) etc) then I'm sure we can build it.

Normal inverse cumulative distribution function - MATLAB norminv - MathWorks United Kingdom

The norminv function uses the inverse complementary error function erfcinv. The relationship between norminv and erfcinv is

norminv(p)=−√2 erfcinv(2p)

The inverse complementary error function erfcinv(x) is defined as erfcinv(erfc(x))=x, and the complementary error function erfc(x) is defined as

erfc(x)=1−erf(x)=2√π∫∞xe−t2dt.

Quick Links

Can you help?

Unanswered questions

Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
An Update on Anaplan Audit Log Reporting: A No-Code Approach
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…