![\"calculations\"](\"https:\/\/www.mrc-productivity.com\/legacy\/images\/calculations1.png\")
<\/a><\/p>\nInput Fields:<\/h3>\n
Field Name- When creating new fields in summaries, you need to specify a field name. This name will be the name of the field in the database.<\/p>\n
Calc Type- Select your calculation type from the dropdown:\u00a0 database, system value, parameter, application, or external object. Database calculations are the most common calculation type, and will meet the needs of most new m-Power developers. For more information on calculation types, click here<\/a>.<\/p>\n Description- Enter a description of the field that will appear in your application.<\/p>\n Data Type- Select either numeric, alpha, or date.<\/p>\n Length- Specify the length of your field.\u00a0 Remember that the calculation may change the expected field length, and in some instances it is a good idea to have a small buffer.\u00a0 Note:\u00a0 <\/strong>the length includes the length of the decimal, and extra digits will automatically be trimmed.\u00a0 For instance, 45.342 will have a length of 5, and a decimal of three.<\/p>\n Format- Select the desired format.\u00a0 m-Power comes equipped with commonly used numeric and date formats. However, you can also design your own formats<\/a>.<\/p>\n Round- If set to yes, the decimal\u00a0 portion of the value will round up if the decimal is greater than or equal to .5 , otherwise the value will round down.\u00a0 If rounding is set to no, the decimal will truncate depending on the specified length.<\/p>\n Calculation- Input your calculation in the largest input box.\u00a0 You may type in your calculation or use the calculator provided.\u00a0 The fields and functions available to use will depend on the calculation type.<\/p>\n m-Power is equipped to add conditions to calculations. Data that matches the requirements of the condition will process the calculation. To add a condition, click Add New. This opens the Conditions box.<\/p>\nConditions<\/h3>\n