2 More Great Prophix Tips: Keyboard Shortcuts and Formulas

On Monday, I went over Security and Accessibility in Prophix.  Here are two more time-saving tips for Prophix.

Combining the use of shortcuts and formulas within a template can help you do budgeting and forecasting quickly.  Prophix 11 has “Excel-like” keyboard shortcuts to make your life easier; they allow you to quickly modify different things depending on the module you’re using. The second tip is to use template functions in formulas. These are also “Excel-like” and allow you to create complex calculations quickly and easily.

Prophix Keyboard Shortcuts

These keyboard shortcuts are meant for Prophix Model Template Designer.

Template Designer Shortcuts

• Ctrl+B = bold the selection
• Ctrl+I = italicize the selection
• Ctrl+U = underline the selection
• Ctrl+A = select all
• Shift+Space = highlight the row
• Ctrl+Space = highlight the column
• Ctrl+Right = move right to last column of the current block of data (or first column of the next block of data)
• Ctrl+Left = move left to the first column of the current block of data (or the last column of the next block of data)
• Ctrl+Up = move up to the first row of the current block of data (or the last row of the next block of data)
• Ctrl+Down = move down to the last row of the current block of data (or the first row of the next block of data)
• Alt+M = display MDX for all data views in the template (runtime mode)

Ad-Hoc Analysis

• F2 = edit current selected cell

Useful Shortcuts

• F1 = Prophix Help wherever you click on this you can get information of the module you are currently in
• CTRL+Tab = Switch between Prophix tabs
• F5 = Refresh Page
• CTRL+S = To save current page

Administrative Shortcuts

***WARNING***

Do not attempt to alter settings without consulting your Prophix Support Team. These are meant for Administrators and Technical Teams to debug issues you maybe having. Use at your own risk! If you are an Encore Customer, feel free to contact us and we can help you out!

• Alt+E = Prophix Error Log, if you have ever seen the notice see Prophix log look no further.
• Alt+D = Prophix Debug mode use this to turn it on and off and check the Prophix Error Log.
• Alt+T = Alter Debug Tracing setup
• Alt+U = Alter AMO settings from developer default to custom

*** / WARNING***

Prophix Tips and Tricks: Formulas

Function	Description
And	Returns True if all arguments are True
If	Tests a logical condition and returns one of the two alternatives
Not	Negates a logical value
Or	Returns True if at least one argument is True
Concatenate	Joins arguments into a single string
Left	Returns left so many characters in a string
Right	Returns right so many characters in a string
Text	Returns a formatted string
Value	Returns a number from a string
Len	Returns the length of a string
MID	Returns a text segment of a character string
HLookUp	Finds a value in one row and returns the corresponding value in another
VLookUp	Finds a value in one column and returns the corresponding value in another
IsError	Returns True if cell holds an error
IsNumber	Returns True if cell holds a number
Date	Returns the serial number date
Datevalue	Returns the serial number date from a string
Day	Returns the day of the month
Days360	Returns the number of days between two dates using 360-day year
Hour	Returns the hour from 0 to 23
Minute	Returns the minute from 0 to 59
Month	Returns the month from 1 to 12
Now	Returns the current date and time
Second	Returns the second from 0 to 59
Time	Returns serial number time
Timevalue	Returns the serial number time from a string
Today	Returns the current date
Weekday	Returns the weekday from 1 to 7
Year	Returns the year from 1900 to 9999
Db	Returns the depreciation using fixed declining balance calculation
Ddb	Returns the depreciation using double declining balance calculation
Fv	Returns future value of an investment
Ipmt	Returns interest payment
Irr	Returns internal rate of return
Ispmt	Returns interest payment
Mirr	Returns internal rate of return
Nper	Returns number of payment periods
Npv	Returns net present value
Pmt	Returns loan payment
Ppmt	Returns principal payment
Pv	Returns present value
Rate	Returns interest rate per period
Sln	Returns straight-line depreciation
Syd	Returns sum-of-years depreciation
Vdb	Returns the depreciation using double declining balance calculation
Abs	Returns the absolute value of a value
Acos	Returns the inverse cosine
Acosh	Returns the inverse hyperbolic cosine
Asin	Returns the inverse sine
Asinh	Returns the inverse hyperbolic sine
Atan	Returns the inverse tangent
Atan2	Returns the inverse tangent
Atanh	Returns the inverse hyperbolic tangent
Avg	Returns the arithmetic mean of the listed arguments
Ceiling	Returns the rounded up value
Combin	Returns the number of combinations
Cos	Returns the cosine
Cosh	Returns the hyperbolic cosine
Degrees	Returns the degrees represented by the given radians
Even	Returns the number rounded up to the nearest event integer
Exp	Returns the value of e raised to the given argument
Fact	Returns the factorial of the given value
Floor	Returns the value rounded down to the nearest value
Int	Returns the value rounded down to nearest integer
Ln	Returns the natural logarithm of the value
Log	Returns the logarithm to a given base
Log10	Returns the logarithm base 10
Mod	Returns the remainder after a division
Odd	Returns the value to the nearest odd integer
Pi	Returns the pi
Pow	Returns the value of one number raised to another number
Product	Returns the product of the listed values
Radians	Returns the radians from given degrees
Rand	Returns a random value
Round	Returns the number to a specified number of digits
Rounddown	Returns the number rounded down
Roundup	Returns the number rounded up
Sign	Returns the sign of the number
Sine	Returns the sine
Sinh	Returns the hyperbolic sine
Sqrt	Returns the square root of a number
Sum	Returns the sum of the listed values
Sumif	Returns the conditional sum of the listed values
SumProduct	Returns the sum of the products
Sumsq	Returns the sum of the squares
Sumx2my2	Returns the differences of the squares
Sumx2py2	Returns the sum of the sum of the squares
Sumxmy2	Returns the squares of the differences
Tan	Returns the tangent
Tanh	Returns the hyperbolic tangent
Trunc	Returns the number without a fractional part
Avedev	Returns average deviation
Average	Returns the arithmetic mean
Averagea	Returns the arithmetic mean
Binomdist	Returns the cumulative beta probability density function
Chidist	Returns the chi-squared distribution
Chiinv	Returns the inverse of Chidist
Chitest	Returns the chi-squared distribution test for independence
Confidence	Returns the confidence interval
Correl	Returns the correlation between two sets of data
Count	Returns the count of the data listed in the arguments
Counta	Returns the count of the data listed in the arguments
Countblank	Returns the count of the empty cells listed in the arguments
Countif	Returns the count of values that meet a specified criteria
Covar	Returns covariance
CritBinom	Returns the critical value for the cumulative binomial distribution
Devsq	Returns the sum of the squares of the mean deviation
Expondist	Returns the exponential distribution
Fdist	Returns the F probability distribution
Finv	Returns the inverse of Fdist
Fisher	Returns the Fisher transformation
Fisherinv	Returns the inverse of Fisher
Forecast	Returns the value forecasted by the linear trend
Gammadist	Returns the gamma distribution
Gammainv	Returns the inverse of Gammadist
Gammaln	Returns the natural logarithm of gamma function
Geomean	Returns the geometric mean
Harmean	Returns the harmonic mean
Hypgeomdist	Returns the hypergeometric distribution
Intercept	Returns the Y intercept of the least squares fit line
Kurt	Returns the kurtosis of the set of arguments
Large	Returns the kth largest value
Loginv	Returns the inverse of the Lognormdist
Lognormdist	Returns the cumulative lognormal distribution function
Max	Returns the largest value among the arguments
Maxa	Returns the largest value among the arguments
Median	Returns the median value among the arguments
Min	Returns the smallest value among the arguments
Mina	Returns the smallest value among the arguments
Mode	Returns the most frequently occurring value
Negbinomdist	Returns the negative binomial distribution
Normdist	Returns the normal cumulative distribution
Norminv	Returns the inverse of Normdist
Pearson	Returns the Pearson product
Percentile	Returns the kth percentile of the given values
Percentrank	Returns the position of a value in the range of values
Permut	Returns the number of permutations
Poisson	Returns the Poisson distribution
Prob	Returns a probability
Quartile	Returns which quarter a value belongs to within an ordered set of data
Rank	Returns the position of a value in an ordered list
Rsq	Returns the square of the Pearson product moment correlation coefficients
Skew	Returns the skewness of a distribution
Slope	Returns the slope of the linear regression line
Small	Returns the kth smallest value
Standardize	Returns the normalized value
Stdev	Returns the sample standard deviation
Stdeva	Returns the sample standard deviation
Stdevp	Returns the population standard deviation
Stdevpa	Returns the population standard deviation
Steyx	Returns the standard error
Trimmean	Returns the mean after removing out-liers
Var	Returns the sample variance
Vara	Returns the sample variance
Varp	Returns the population variance
Varpa	Returns the population variance
Weibull	Returns the Weibull distribution
Ztest	Returns the P-value of a z-test