--- title: "Deltek Vision Tip: Calculated Fields | BCS ProSoft" description: If you can select columns for a report, you can also use the Add/Modify Calculated Field dialog box to add your own calculated fields to the report. Calcul --- Questions? Give us a a call at [**(855) 982-9336**](https://www.bcsprosoft.com/contact/) - [Facebook](https://www.facebook.com/bcsprosoft) - [Linkedin](https://www.linkedin.com/company/bcs-prosoft) - [Twitter](https://twitter.com/bcsprosoft) - [Email](https://www.bcsprosoft.com/contact/) [![BCS-logo-white-red-2](https://blog.bcsprosoft.com/hs-fs/hubfs/BCS-logo-white-red-2.png?width=700&name=BCS-logo-white-red-2.png)](https://www.bcsprosoft.com/) - Products - Deltek - [Deltek](https://www.bcsprosoft.com/deltek/) - [Deltek Vantagepoint](https://www.bcsprosoft.com/deltek/vantagepoint/) - [Deltek Cloud](https://www.bcsprosoft.com/deltek/cloud/) - [Deltek PIM](https://www.bcsprosoft.com/deltek/pim/) - [Deltek CRM](https://www.bcsprosoft.com/deltek/crm/) - Sage - [Sage Intacct](https://bcsprosoft.com/sage-intacct/) - [Sage 100cloud](https://www.bcsprosoft.com/sage-100/cloud/) - [Sage CRM](https://www.bcsprosoft.com/sage-crm/) - [Sage HRMS](https://www.bcsprosoft.com/sage-hrms/) - [NetSuite](https://www.bcsprosoft.com/netsuite/) - [Automated Rental (ARM)](https://www.armsoftware.com/?utm_source=bcsprosoft.com&utm_medium=referral) - [Services](https://www.bcsprosoft.com/services/) - Resources - Blog - [Deltek Blog](https://blog.bcsprosoft.com/tag/deltek/) - [Sage Blog](https://blog.bcsprosoft.com/tag/sage) - [NetSuite Blog](https://blog.bcsprosoft.com/tag/netsuite) - Whitepapers - [Deltek Whitepapers](https://www.bcsprosoft.com/resources/deltek-whitepapers/) - [Sage Whitepapers](https://www.bcsprosoft.com/resources/sage-whitepapers/) - [NetSuite Whitepapers](https://www.bcsprosoft.com/resources/netsuite-whitepapers/) - Product Guides - [Deltek Product Guides](https://www.bcsprosoft.com/resources/deltek-product-guides/) - [Sage Product Guides](https://www.bcsprosoft.com/resources/sage-product-guides/) - [NetSuite Product Guides](https://www.bcsprosoft.com/resources/netsuite-product-guides/) - Webinars - [Deltek Webinars](https://www.bcsprosoft.com/resources/deltek-webinars/) - [Sage Webinars](https://www.bcsprosoft.com/resources/sage-webinars/) - [NetSuite Webinars](https://www.bcsprosoft.com/resources/netsuite-webinars/) - Company - [About Us](https://www.bcsprosoft.com/about/) - [Industries](https://www.bcsprosoft.com/industries/) - [Events](https://www.bcsprosoft.com/events/) - [Careers](https://www.bcsprosoft.com/careers/) - [Support](https://www.bcsprosoft.com/support/) - [Referral Program](https://www.bcsprosoft.com/bcs-referral/) - [Contact Us](https://www.bcsprosoft.com/contact/) # Deltek Vision Tip: Calculated Fields By [Taylor Wise](https://blog.bcsprosoft.com/author/taylor-wise) | Apr 25th, 12 | Categories: [Tips and Tricks](https://blog.bcsprosoft.com/tag/tips-and-tricks), [Deltek Vision](https://blog.bcsprosoft.com/tag/deltek-vision), [Tips & Tricks](https://blog.bcsprosoft.com/tag/tips-tricks), [Deltek](https://blog.bcsprosoft.com/tag/deltek), [Modify Calculated Field](https://blog.bcsprosoft.com/tag/modify-calculated-field), [Add Calculated Field](https://blog.bcsprosoft.com/tag/add-calculated-field), [Multiple Reports](https://blog.bcsprosoft.com/tag/multiple-reports), [Pending Update](https://blog.bcsprosoft.com/tag/pending-update) If you can select columns for a report, you can also use the Add/Modify Calculated Field dialog box to add your own calculated fields to the report. Calculated fields that you create with this dialog box are for the selected report only. If you need a calculated field for multiple reports, your system administrator can create it with the Calculated Fields form in Configuration. Global calculated fields cannot be modified for individual reports. To open the Add/Modify Calculated Field dialog box, do one of the following: • To create a new calculated field, click: New calculation on the Columns tab in the Options dialog box for the report. • To modify an existing calculated field, click in the row for the field in the grid on the Columns tab and then click Edit calculation. **Calculator** Use the Calculator options to create simple calculations using numbers, math operators (/, \*, -, +), brackets, and parentheses. To enclose all or part of the calculation in parentheses, select that part of the calculation in Calculation and click (..Exp..). You do not have to use Calculator to select a number or symbol. You can also enter them directly in Calculation. For example, you could use the keyboard to enter the following: \[ JTD Amount\] – \[Compensation\] **Use a Condition** The Use a Condition options make enable you to create more complex calculations. To use the options, select the Use a Condition check box. **Example:** This calculation shows the year-to-date amount for the Boston office: If this is true: \[Office\] = ” BO” Use this calculation: \[Year-to-Date Amount\] Otherwise, use this calculation: 0 [![](https://blog.bcsprosoft.com/hs-fs/hubfs/Imported_Blog_Media/deltek-vision-modify-calculated-field-300x168.jpg?width=300&height=168&name=deltek-vision-modify-calculated-field-300x168.jpg "deltek-vision-modify-calculated-field")](https://blog.bcsprosoft.com/hubfs/Imported_Blog_Media/deltek-vision-modify-calculated-field.jpg) Click to enlarge Use the LIKE condition with one or more asterisks (\*) as wildcards to base the calculation on the presence of specific text in a field. **Example:** If this is true: \[EmployeeName\] LIKE “John\*” — “Johnson” and “Johnston” satisfy the condition. The New calculation and Edit calculation options are also available on the Metrics tab of the Options dialog box for the Key Financial Metrics report. The information in this topic applies to those options also. [![](https://blog.bcsprosoft.com/hs-fs/hubfs/Imported_Blog_Media/deltek-vision-modify-calculated-field2-300x168.jpg?width=300&height=168&name=deltek-vision-modify-calculated-field2-300x168.jpg "deltek-vision-modify-calculated-field2")](https://blog.bcsprosoft.com/hubfs/Imported_Blog_Media/deltek-vision-modify-calculated-field2.jpg) Click to enlarge Formulas are a great way to get more information out of your Deltek Vision system. You can’t hurt anything by playing around with this feature, so why not give it a try! If you have questions or need help, leave a comment below or give me a call. I’m here to help!     #### Share this post with a friend or coworker! - - - - [mailto:?subject=Deltek%20Vision%20Tip:%20Calculated%20Fields&body=https://blog.bcsprosoft.com/deltek-vision-tip-calculated-fields](mailto:?subject=Deltek%20Vision%20Tip:%20Calculated%20Fields&body=https://blog.bcsprosoft.com/deltek-vision-tip-calculated-fields) ### Related posts ![6 Ways to Make the Most of Deltek Vantagepoint's Enhanced Dashboard](https://blog.bcsprosoft.com/hs-fs/hubfs/blog-thumbnail-deltek-vantagepoint-dashboards-04.jpg?width=200&name=blog-thumbnail-deltek-vantagepoint-dashboards-04.jpg) [6 Ways to Make the Most of Deltek Vantagepoint's Enhanced Dashboard](https://blog.bcsprosoft.com/deltek-vantagepoint-enhanced-dashboard) Jul 26th, 22 ![Your Top 5 Concerns about Deltek Cloud Addressed](https://blog.bcsprosoft.com/hs-fs/hubfs/Blog-Thumbnail-Banner-Top-5-Concerns-About-Deltek-Cloud-Addressed-BCS-ProSoft-03-03.jpg?quality=high&width=200&name=Blog-Thumbnail-Banner-Top-5-Concerns-About-Deltek-Cloud-Addressed-BCS-ProSoft-03-03.jpg) [Your Top 5 Concerns about Deltek Cloud Addressed](https://blog.bcsprosoft.com/your-top-5-concerns-about-deltek-cloud-erp-addressed) Jun 9th, 21 ![Extend the Functionality of Your Sage Intacct Solution: Learn More at Wednesday Wisdom](https://blog.bcsprosoft.com/hs-fs/hubfs/Imported_Blog_Media/SI-Wed-Wisdom.jpg?width=200&name=SI-Wed-Wisdom.jpg) [Extend the Functionality of Your Sage Intacct Solution: Learn More at Wednesday Wisdom](https://blog.bcsprosoft.com/extend-the-functionality-of-your-sage-intacct-solution-learn-more-at-wednesday-wisdom) Mar 24th, 21 [Services Sales Tax Spreads Through States](https://blog.bcsprosoft.com/services-sales-tax-spreads-states) Feb 8th, 21 ![BCS ProSoft Chosen as one of Bob Scott’s VAR Stars 2020!](https://blog.bcsprosoft.com/hs-fs/hubfs/How-to-Integrate-NetSuite-Forms-with-Recaptcha-BCS-ProSoft-03.jpg?quality=high&width=200&name=How-to-Integrate-NetSuite-Forms-with-Recaptcha-BCS-ProSoft-03.jpg) [BCS ProSoft Chosen as one of Bob Scott’s VAR Stars 2020!](https://blog.bcsprosoft.com/bcs-prosoft-chosen-as-var-stars-2020) Jan 5th, 21 ![The Best Thing about Sage Intacct Budgeting and Planning? Saying “Goodbye” to Spreadsheet Headaches and Busy Work!](https://blog.bcsprosoft.com/hs-fs/hubfs/Imported_Blog_Media/SI-BP-Blog-Header.jpg?width=200&name=SI-BP-Blog-Header.jpg) [The Best Thing about Sage Intacct Budgeting and Planning? Saying “Goodbye” to Spreadsheet Headaches and Busy Work!](https://blog.bcsprosoft.com/sage-intacct-budgeting-planning-series) Nov 19th, 20 This is a search field with an auto-suggest feature attached. - There are no suggestions because the search field is empty. ### Recent Posts ### Who is BCS ProSoft? We’re a business technology provider and consulting firm specializing in NetSuite, Deltek and Sage software systems. We’re a Top 30 VAR and ready to get started on your project. Need help? [Let’s talk.](https://www.bcsprosoft.com/contact/) ![BCS-logo-white-red-2](https://blog.bcsprosoft.com/hs-fs/hubfs/BCS-logo-white-red-2.png?width=211&name=BCS-logo-white-red-2.png) BCS ProSoft is a leading business management technology provider and professional services firm specializing in Sage, Deltek, and NetSuite ERP systems. Based out of San Antonio, Texas, BCS ProSoft serves more than 1,500 clients from its offices in Houston, Denver, Honolulu, and Monterrey, Mexico. ### **Products** - [Deltek](https://www.bcsprosoft.com/deltek/) - [Sage Intacct](https://www.bcsprosoft.com/sage-intacct-overiew/) - [Sage 100](https://www.bcsprosoft.com/sage-100/cloud/) - [NetSuite](https://www.bcsprosoft.com/netsuite/) - [Automated Rental (ARM)](https://www.armsoftware.com/) ### **Company** - [About Us](https://www.bcsprosoft.com/about/) - [Industries](https://www.bcsprosoft.com/industries/) - [Events](https://www.bcsprosoft.com/events/calendar/) - [Careers](https://www.bcsprosoft.com/careers/) - [Support](https://www.bcsprosoft.com/support/) - [Referral Program](https://www.bcsprosoft.com/resource/bcs-referral/) © Copyright 2008-2021, BCS ProSoft, LLC. All rights reserved. | [Legal](https://www.bcsprosoft.com/legal) | [Privacy Policy](https://www.bcsprosoft.com/privacy/) - [Facebook](https://www.facebook.com/bcsprosoft) - [Linkedin](https://www.linkedin.com/company/bcs-prosoft) - [Twitter](https://twitter.com/bcsprosoft) - [Email](https://www.bcsprosoft.com/contact/)