Using Excel function in Anaplan

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

Issue with Anaplan tab in Salesforce
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Data Integration to Fluence workspace
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…