- Welcome to the Knowledge Base
- Introduction
- Training
- Getting Started
- Preferences
- Activities
- Cases
- Forecasts & Quotas
- Importing Data
- Leads
-
Marketing
- Introduction to Marketing
- Marketing Campaigns
- Mailing Lists
- Products
- Mailshots
- Upload Library
- Templates
- Event Management
- Compliance Records
-
Spotler Integration
- What is Spotler?
- Navigating your Spotler homepage
- GatorMail
-
GatorLeads / Web Insights
- Tracking Code
- Setting up the Plugin
- Viewing Web Insights Data on your Form Layouts
- Domain Names and Online Activities
- Reporting incorrect Leads created through Web Insights
- Reporting on Web Insights data
- Using UTM Values
- Why aren’t Online Activities being created in the database?
- Why is GatorLeads recording online activities in a foreign language?
- GatorSurvey
- GatorWorkflow
- GatorPopup
- Opportunities
-
Integrations
- Mapping
- Electronic Signing Tools
- Creditsafe Integration
-
Zapier
- Introduction to Zapier
- Available Triggers and Actions
- Linking your Workbooks Account to Zapier
-
Setting up Zaps
- Posted Invoices to Xero Invoices
- Xero payments to Workbooks Tasks
- New Case to Google Drive folder
- New Case to Basecamp Project
- New Workbooks Case to JIRA Ticket
- Jira Issue to new Case
- 123FormBuilder Form Entry to Case
- Eventbrite Attendee to Sales Lead and Task
- Facebook Ad Leads to Sales Leads
- Wufoo Form Entry to Sales Lead
- Posted Credit Note to Task
- QuickBooks Online
- Survey Monkey responses to Tasks
- Multistep Zaps
-
Email Integrations
- Email Dropbox
- Workbooks Exchange Server Sync
- Workbooks Outlook Connector
- RevenueGrid Intelligence and Engage
-
Event & Webinar Integration Tools
- GoToWebinar
- ON24
- Microsoft Office
-
Outreach
- Installation
- Outreach Authentication
- Sync People to Outreach Prospects
- Sync Organisations to Outreach Accounts
- Sync Workbooks Opportunities to Outreach
- Sync Tasks/Activities from Workbooks to Outreach
- Sync Outreach Sequences to Workbooks
- Sync Outreach Sequence States to Workbooks
- Sync Outreach Sequence Step Numbers to Workbooks
- Sync Prospects/Accounts/Opportunities from Outreach to Workbooks
- Sync Outreach Tasks/Calls/Meetings to Workbooks
- Scribe/Workbooks Connector
- RingCentral
- Auditing
- Comments
- People & Organisations
- Projects
-
Reporting
- Introduction to Reporting
- Using Reports
- Charts
- Exporting Reports
- Advanced Reporting
- Report Snapshots
- Dashboards
-
Transaction Documents
-
Introduction to Transaction Documents
- Displaying & Adding Transaction Documents
- Copying Transaction Documents
- Transaction Documents Fields Help
- Transaction Documents Line Items Help
- Printing & Sending Transaction Documents
- Managing Transaction Document Currencies
- Managing Transaction Document Statuses
- Setting a Blank Default Currency on Transaction Documents
- Credit Notes
- Customer Orders
- Invoices
- Quotations
- Supplier Orders
- Contract Management
- Sagelink
-
Introduction to Transaction Documents
- Auditing
-
Configuration
- Introduction to System Administration
- Users & Security
- Preferences
- Database
- Accounting
- Email & Integration
-
Customisation
- Creating & Modifying Picklists
- Theme
-
Record Types
- Creating Custom Fields
- Report-based Custom Fields
- Linked Fields & Reference Fields
- Record Templates
- Form Layouts
- Customising relationships between parties
- Opportunity Stages
- Custom Records
- Automation
- PDF Configuration
- Contact Support
- Releases & Roadmap
Calculated Targets
It is possible to use Calculated Columns as a way to set targets in a Report. These can be Custom Fields, such as an “Annual Budget” Field on an Organisation Record. Alternatively you can use calculated Columns to create a very simple single value targets or a more complex calculations based on a number of different criteria.
This Knowledge Base page will focus primarily on using Calculated Columns to create a Target, however the same principles can be applied to any numeric column within a Report View.
To create a Calculated Target you will first need to create a calculated column on the same View as the Actual Value Column (the Calculated Target Column can be hidden from the View if needed). This page will talk you through how to build a number of different Calculated Targets from the Summary View of a pre-populated Opportunity Report.
To create this Report go to Start > New > Report > Create a pre-populated Report > Opportunities. Once the Report has been created you will need to Add a Summary View to the Report, using the Assigned to as a Grouping Column and creating a Subtotal Column for the Amount (home currency) Field.
Setting up a simple Calculated Target
To set up a basic calculated Target create a calculated column called “Target Value” on the Summary View, in the Formula Field enter a numeric value, for this example we will use 800000.
Once this is added open the subtotal column (Total Amount (home currency)), and go to the Targets Tab and select “Get target values from another column” this will allow you to select the Target Value column. As with all Targets you can show which values from Actual, Target, Achieved Percentage and Difference are displayed in the Report.
Save and close the Subtotal Column and this will generate the new targeted column, you can then hide the Target Value column from the view to produce a Report like below:
This will display the Totals of the Target and the Total Percentage of the Target that has been achieved as well as each individual’s performance against the Target.
Creating a complex Calculated Target
As with the simple Calculated Target you will need to create a Calculated Column called Target Value, however rather than set a single value for the Target you can use a CASE Statement to create Custom Targets for each Person such as:
CASE PARENT('Assigned to name') WHEN "Alison Jones" THEN 250000 WHEN "Daniel Demo" THEN 150000 WHEN "Dylan Jackson" THEN 500000 WHEN "Jane Fretwell" THEN 225000 ELSE 200000 END
Open the subtotal column (Total Amount (home currency)), and go to the Targets Tab and select “Get target values from another column” this will allow you to select the Target Value Column. As with all Targets you can show which values from Actual, Target, Difference and Achieved are displayed in the Report.
As with the basic Calculated Target each User has their own individual target as well as the overall total being shown for the Report view: