Figure 73: Computed Expressions—Example of dialogue encountered with a COMPUTED field with expected numeric result (2 of 3) SHOULD VALUE ALWAYS BE INTERNALLY ROUNDED TO 0 DECIMAL PLACES? No// <Enter> (No) Since the value of a COMPUTED field can be used in other calculations, you need to indicate when rounding should occur. If you accept the default (i.e., rounding is done when the COMPUTED not “No”), field is used in other calculations. A YES answer to this prompt means that you do want the rounded value used in calculations. Usually, you do want values rounded at interim steps in a series of not calculations. Thus, usually, you accept the default. “No” When a COMPUTED field is printed, the value is always rounded to the number of decimal places you specify. Figure 74: Computed Expressions—Example of dialogue encountered with a COMPUTED field with expected numeric result (3 of 3) WHEN TOTALLING THIS FIELD, SHOULD THE SUM BE COMPUTED FROM THE SUMS OF THE COMPONENT FIELDS? No// <Enter> (No) If your computed expression involves division or multiplication, you are asked how the field should be totaled. (You can total the values of a field in the Print File Entries option.): A NO answer to this prompt means that the COMPUTED expression is evaluated for each field’s entry and those results are added. A YES answer means that values of each of the fields in the COMPUTED expression is field’s added first and then the COMPUTED expression is applied to those totals. field’s For example, suppose and are the names of two fields and is a computed expression. The table A B A/B below shows the results of printing A, B, and A/B with different answers to the TOTALLING “WHEN THIS FIELD, ...” question: Table 10: Computed Expressions—Example Indicating Possible Results of Computed Expression Based on Different Entries to “Totaling” Prompt A B A/B A/B (YES: Total from totals of (NO: Total from results for component fields) each entry) 10 5 2 2 100 50 2 2 2 1 2 2 Total 112 56 [112/56=] 2 [2+2+2=] 6 To summarize, if you want the total to be the ratio or product of the total of the component fields, then answer this question YES. Otherwise, a NO answer is appropriate.
Figure 73: Computed Expressions—Example of dialogue encountered with a COMPUTED field with expected numeric result (2 of 3) SHOULD VALUE ALWAYS BE INTERNALLY ROUNDED TO 0 DECIMAL PLACES? No// <Enter> (No) Since the value of a COMPUTED field can be used in other calculations, you need to indicate when rounding should occur. If you accept the default (i.e., “No”), rounding is not done when the COMPUTED field is used in other calculations. A YES answer to this prompt means that you do want the rounded value used in calculations. Usually, you do not want values rounded at interim steps in a series of calculations. Thus, usually, you accept the “No” default. When a COMPUTED field is printed, the value is always rounded to the number of decimal places you specify. Figure 74: Computed Expressions—Example of dialogue encountered with a COMPUTED field with expected numeric result (3 of 3) WHEN TOTALLING THIS FIELD, SHOULD THE SUM BE COMPUTED FROM THE SUMS OF THE COMPONENT FIELDS? No// <Enter> (No) If your computed expression involves division or multiplication, you are asked how the field should be totaled. (You can total the values of a field in the Print File Entries option.): A NO answer to this prompt means that the COMPUTED field’s expression is evaluated for each entry and those results are added. A YES answer means that values of each of the fields in the COMPUTED field’s expression is added first and then the COMPUTED field’s expression is applied to those totals. For example, suppose A and B are the names of two fields and A/B is a computed expression. The table below shows the results of printing A, B, and A/B with different answers to the “WHEN TOTALLING THIS FIELD, ...” question: Table 10: Computed Expressions—Example Indicating Possible Results of Computed Expression Based on Different Entries to “Totaling” Prompt A B A/B (YES: Total from totals of component fields) A/B (NO: Total from results for each entry) 10 5 2 2 100 50 2 2 2 1 2 2 Total 112 56 [112/56=] 2 [2+2+2=] 6 To summarize, if you want the total to be the ratio or product of the total of the component fields, then answer this question YES. Otherwise, a NO answer is appropriate.
fm22_2um2.docx