Question:
Why are numbers missing from my BFA‘s Division Totals worksheet?
Why are numbers missing from my BFA‘s Billing Code Totals worksheet?
Answer:
It is very possible that the columns with the missing numbers in your BFA workbook are User Calc Field columns (i.e., columns that are user defined to hold a formula or calculation.) Because formulas constructed in the User Calc Field columns rely on ‘Defined Names‘ to locate the appropriate columns on the Data worksheet, and because ‘Defined Names‘ are worksheet specific, user-defined formulas fail when applied in the Division Totals and Billing Code Totals worksheets.
Functionality allows the BFA workbook to convert user-defined formulas for use in the Division Totals and Billing Code Totals worksheets. On the Site Setting level (on the Setup worksheet) you can indicate how you want subtotal rows on the Division Totals or Billing Code Totals worksheet to be calculated.
Your choices for the User Calc Field columns are
- F – to use the formula indicated for the column (in row 61) converted to the appropriate worksheet (Division Totals or Billing Code Totals)
- N – to leave the cell blank (no value). This option is used by Spitfire whenever the resulting value created by a sum or formula is invalid, such as when adding units with different units of measure.
- S – to use the sum of the constituent amounts. This option is often used for money.
Additional Comments:
For more information, see the User Calc Field Column section in the Focus on the BFA Workbook guide.
KBA-01464; Last updated: September 18, 2017 at 11:39 am;
Keywords: BFA workbook, Setup worksheet, user defined formulas,