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. 
Disclaimer
We update Anapedia content regularly to provide the most uptodate instructions.