Comparisons of Microsoft Excel functions to those available in Anaplan.
|Excel function||Excel description||Anaplan solution|
|PERCENTILE||Returns the nth percentile from a set of values.||There is no equivalent Anaplan function, but can be built using a calculation.|
|PERCENTRANK||Returns the rank of a value in a set of values as a percentage of the set.|
There is no equivalent Anaplan function, but can be built using a calculation.
|PERMUT||Returns the number of permutations for a specified number of items.|
Use the POWER function for permutations where repetition is allowed, where:
|PI||Returns the mathematical constant called pi.||There is no equivalent Anaplan function, but can be built using a calculation.|
|PMT||Returns the payment amount for a loan.||Use the PMT formula to take a date as a parameter and return a time period as a result.|
|POWER||Returns the result of a number raised to a given power.||Use the POWER function.|
|PPMT||Returns the payment on the principal for a particular payment.||See the Financial Functions.|
|PRICE||Returns the price per $100 face value of a security that pays periodic interest.||Use the PRICE function.|
|PRODUCT||Multiplies the numbers and returns the product.||Use an intermediate line item with the summary as the product.|
|PROPER||Sets the first character in each word to uppercase and the rest to lowercase.||There is no equivalent Anaplan function, but can be built using a calculation.|
|PV||Returns the present value of an investment.||Use the PV function to calculate the present value of future cash flows.|
We update Anapedia content regularly to provide the most up-to-date instructions.