{"id":31342,"date":"2021-01-19T12:08:17","date_gmt":"2021-01-19T12:08:17","guid":{"rendered":"https:\/\/support.ospreyapproach.com\/?post_type=pracctice_guide&#038;p=31342"},"modified":"2024-12-19T16:38:16","modified_gmt":"2024-12-19T16:38:16","slug":"report-writer-creating-calculated-fields","status":"publish","type":"pracctice_guide","link":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/","title":{"rendered":"Creating Calculated Fields"},"content":{"rendered":"<div class=\"card\">\n\n    <p class=\"mb-2\"><strong>Who is this guide for?<\/strong><\/p>\n    <p class=\"mb-0\"><i class=\"far fa-user fa-fw mr-2\"><\/i> <strong>System Supervisors<\/strong> and <strong>Report Designers<\/strong><\/p>    \n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">When designing your own reports, you may wish to merge together one or more fields, or create a value based on other values in your report data set. This guide will show you how<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">For example, given the client title, forename and surname as separate fields you may wish to make a &#8220;Client Name&#8221; field which shows just the company name if a company, but the Title, Forename and Surname in one field if an individual.<\/p>\n\n\n\n<p class=\"h2 wp-block-paragraph\"><strong>Create a new Calculated Field<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To create a new calculated field, in the report designer, right click on the Field List in the top right hand corner, then click Add Calculated Field. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1353\" height=\"1033\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/01\/Add-Calcd-field.gif\" alt=\"Add a calculated field\" class=\"wp-image-31343\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Give the new field a name which can be used to identify it &#8211; this must be different to any of the other field names which already exist in your view, and cannot contain any spaces.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1353\" height=\"1033\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/01\/Rename-Field.gif\" alt=\"Name your calculated field\" class=\"wp-image-31353\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Click into the Expression box, and click the ellipsis button (&#8230;)<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1353\" height=\"1033\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/01\/Edit-Expression.gif\" alt=\"Set calculated expression\" class=\"wp-image-31344\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The Expression Editor will now open for you to create your new field.<\/p>\n\n\n\n<p class=\"h2 wp-block-paragraph\"><strong>Using the Expression Editor &#8211; Functions pane<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Functions can be used to manipulate data in the same way as Excel formulae. Select the Functions option in the leftmost panel, you can then break the functions down by type, and then double click to add the function to the expression editor box. Selecting a function with a single click will display a description of its&#8217; usage in the rightmost panel. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"787\" height=\"626\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/01\/Choose-Function-Type.gif\" alt=\"Choose function\" class=\"wp-image-31354\" \/><\/figure>\n\n\n\n<p class=\"h2 wp-block-paragraph\"><strong>Using the Expression Editor &#8211; Fields pane<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Selecting the Fields pane allows you to select any of the fields available in your data set. Selecting a field with a single click will display its&#8217; data type in the rightmost panel. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"787\" height=\"626\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/01\/Choose-Field.gif\" alt=\"Choose field\" class=\"wp-image-31355\" \/><\/figure>\n\n\n\n<p class=\"h2 wp-block-paragraph\"><strong>Using the Expression Editor &#8211; Constants pane<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Constants available are True, False and ? &#8211; these can be used for comparing True\/False\/Empty field values.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"576\" height=\"462\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-59.png\" alt=\"\" class=\"wp-image-66402\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-59.png 576w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-59-300x241.png 300w\" sizes=\"auto, (max-width: 576px) 100vw, 576px\" \/><\/figure>\n\n\n\n<p class=\"h2 wp-block-paragraph\"><strong>Using the Expression Editor &#8211; Parameters pane<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This section allows you to work with any parameters you may have added. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"856\" height=\"408\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-60.png\" alt=\"\" class=\"wp-image-66403\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-60.png 856w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-60-300x143.png 300w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-60-768x366.png 768w\" sizes=\"auto, (max-width: 856px) 100vw, 856px\" \/><\/figure>\n\n\n\n<p class=\"h2 wp-block-paragraph\"><strong>Building a Calculated Field Expression &#8211; Example 1 &#8211; Client Full Name, Client and Matter No<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Osprey stores your client name as separate fields Client Title, Client Forename, Client Initials, Client Surname. If your report data set contains these fields, but you want to join them together, you can use a calculated field to do this. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the Expression Editor for this calculated field, you can follow the steps below to link the name fields together. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"798\" height=\"605\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/01\/Client-Full-Name-calculated-field.gif\" alt=\"If statement\" class=\"wp-image-31358\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">This translates as:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">IF the client forename field is blank, THEN just display the client surname, ELSE display the client title plus a space plus the client forename plus a space plus the client surname. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This ensures that where you have company clients, no spaces are inserted prior to the surname\/company name in your report. To add any other text (even spaces!) into a calculated field we need to surround it with the single quote &#8211; &#8216; &#8211; character. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Another example below shows a simple calculated field to join the client and matter numbers together with a \/ in between (Client No field PLUS a \/ plus Matter No field): <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"583\" height=\"470\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-61.png\" alt=\"\" class=\"wp-image-66404\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-61.png 583w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-61-300x242.png 300w\" sizes=\"auto, (max-width: 583px) 100vw, 583px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The results of these custom fields are shown below: <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"858\" height=\"538\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-62.png\" alt=\"\" class=\"wp-image-66405\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-62.png 858w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-62-300x188.png 300w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-62-768x482.png 768w\" sizes=\"auto, (max-width: 858px) 100vw, 858px\" \/><\/figure>\n\n\n\n<p class=\"h2 wp-block-paragraph\"><strong>Building a Calculated Field Expression &#8211; Example 2 &#8211; 50% of an amount, 1 month in future from date<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this example we have created a very simple report of bills outstanding including the bill number, bill date and amount remaining. We want to work out what 50% of the remainder is, and the due date which we will set as 14 days from the date of the bill. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"774\" height=\"278\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-63.png\" alt=\"\" class=\"wp-image-66406\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-63.png 774w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-63-300x108.png 300w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-63-768x276.png 768w\" sizes=\"auto, (max-width: 774px) 100vw, 774px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">We will need to add 2 new calculated fields, Percent50Due and DueDate.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For the 50% due field, we can simply multiply the balance remaining field by 0.5 &#8211; although there are many other mathematical formulae you could apply here to get the same result!<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"798\" height=\"605\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/01\/50-percent-due.gif\" alt=\"Balance calculated field\" class=\"wp-image-31364\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">For the Due Date, we&#8217;ll use the AddDays() function to work out 14 days from the bill date:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"798\" height=\"605\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/01\/Due-date.gif\" alt=\"Due date calculated field example\" class=\"wp-image-31369\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The result:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"824\" height=\"521\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-64.png\" alt=\"\" class=\"wp-image-66407\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-64.png 824w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-64-300x190.png 300w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-64-768x486.png 768w\" sizes=\"auto, (max-width: 824px) 100vw, 824px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>When designing your own reports, you may wish to merge together one or more fields, or create a value based on other values in your report data set. This guide will show you how For example, given the client title, forename and surname as separate fields you may wish to make a &#8220;Client Name&#8221; field [&hellip;]<\/p>\n","protected":false},"author":24,"featured_media":0,"template":"","categories":[127],"tags":[],"class_list":["post-31342","pracctice_guide","type-pracctice_guide","status-publish","hentry","category-supervisor-report-writer"],"acf":{"display_as_dashboard_announcement":false,"announcement_title":"","announcement_type":"New feature","announcement_link_text":"Learn more","announcement_image":null},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Creating Calculated Fields - Osprey Approach Customer Support &amp; Training | Osprey Academy<\/title>\n<meta name=\"description\" content=\"Describes how to create calculated fields in your custom reports. These allow you to create further calculations based on other fields\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating Calculated Fields - Osprey Approach Customer Support &amp; Training | Osprey Academy\" \/>\n<meta property=\"og:description\" content=\"Describes how to create calculated fields in your custom reports. These allow you to create further calculations based on other fields\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/\" \/>\n<meta property=\"og:site_name\" content=\"Osprey Approach Customer Support &amp; Training | Osprey Academy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/OspreyApproachUK\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-19T16:38:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2021\/01\/Add-Calcd-field.gif\" \/>\n\t<meta property=\"og:image:width\" content=\"1353\" \/>\n\t<meta property=\"og:image:height\" content=\"1033\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/gif\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@OspreyApproach\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/\",\"name\":\"Creating Calculated Fields - Osprey Approach Customer Support &amp; Training | Osprey Academy\",\"isPartOf\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/01\/Add-Calcd-field.gif\",\"datePublished\":\"2021-01-19T12:08:17+00:00\",\"dateModified\":\"2024-12-19T16:38:16+00:00\",\"description\":\"Describes how to create calculated fields in your custom reports. These allow you to create further calculations based on other fields\",\"breadcrumb\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/#primaryimage\",\"url\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/01\/Add-Calcd-field.gif\",\"contentUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/01\/Add-Calcd-field.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/support.ospreyapproach.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Guides\",\"item\":\"https:\/\/support.ospreyapproach.com\/guides\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Creating Calculated Fields\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/\",\"name\":\"Osprey Approach Customer Support &amp; Training | Osprey Academy\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization\",\"name\":\"Osprey Approach Customer Support &amp; Training | Osprey Academy\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png\",\"contentUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png\",\"width\":201,\"height\":61,\"caption\":\"Osprey Approach Customer Support &amp; Training | Osprey Academy\"},\"image\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/OspreyApproachUK\/\",\"https:\/\/x.com\/OspreyApproach\",\"https:\/\/www.linkedin.com\/company\/ospreyapproach\",\"https:\/\/www.youtube.com\/channel\/UClARKUq_3YvaK01GPvI6_qA\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating Calculated Fields - Osprey Approach Customer Support &amp; Training | Osprey Academy","description":"Describes how to create calculated fields in your custom reports. These allow you to create further calculations based on other fields","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/","og_locale":"en_GB","og_type":"article","og_title":"Creating Calculated Fields - Osprey Approach Customer Support &amp; Training | Osprey Academy","og_description":"Describes how to create calculated fields in your custom reports. These allow you to create further calculations based on other fields","og_url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/","og_site_name":"Osprey Approach Customer Support &amp; Training | Osprey Academy","article_publisher":"https:\/\/www.facebook.com\/OspreyApproachUK\/","article_modified_time":"2024-12-19T16:38:16+00:00","og_image":[{"width":1353,"height":1033,"url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2021\/01\/Add-Calcd-field.gif","type":"image\/gif"}],"twitter_card":"summary_large_image","twitter_site":"@OspreyApproach","twitter_misc":{"Estimated reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/","name":"Creating Calculated Fields - Osprey Approach Customer Support &amp; Training | Osprey Academy","isPartOf":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/#primaryimage"},"image":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/#primaryimage"},"thumbnailUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/01\/Add-Calcd-field.gif","datePublished":"2021-01-19T12:08:17+00:00","dateModified":"2024-12-19T16:38:16+00:00","description":"Describes how to create calculated fields in your custom reports. These allow you to create further calculations based on other fields","breadcrumb":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/#primaryimage","url":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/01\/Add-Calcd-field.gif","contentUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/01\/Add-Calcd-field.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-creating-calculated-fields\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/support.ospreyapproach.com\/"},{"@type":"ListItem","position":2,"name":"Guides","item":"https:\/\/support.ospreyapproach.com\/guides\/"},{"@type":"ListItem","position":3,"name":"Creating Calculated Fields"}]},{"@type":"WebSite","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/","name":"Osprey Approach Customer Support &amp; Training | Osprey Academy","description":"","publisher":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization","name":"Osprey Approach Customer Support &amp; Training | Osprey Academy","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/","url":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png","contentUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png","width":201,"height":61,"caption":"Osprey Approach Customer Support &amp; Training | Osprey Academy"},"image":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/OspreyApproachUK\/","https:\/\/x.com\/OspreyApproach","https:\/\/www.linkedin.com\/company\/ospreyapproach","https:\/\/www.youtube.com\/channel\/UClARKUq_3YvaK01GPvI6_qA"]}]}},"_links":{"self":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/31342","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide"}],"about":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/types\/pracctice_guide"}],"author":[{"embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/users\/24"}],"version-history":[{"count":3,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/31342\/revisions"}],"predecessor-version":[{"id":69044,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/31342\/revisions\/69044"}],"wp:attachment":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/media?parent=31342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/categories?post=31342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/tags?post=31342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}