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 |
Get the full report on the top BI Vendors.