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
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.
Hey @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,
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.
Can you tell how do we build it in Anaplan
Sorry for that
I want to build NORMINV Excel function in the Anaplan
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
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.…