{"id":2589,"date":"2020-02-13T17:26:03","date_gmt":"2020-02-13T17:26:03","guid":{"rendered":"https:\/\/support.ospreyapproach.com\/?post_type=pracctice_guide&#038;p=2589"},"modified":"2024-05-24T08:09:46","modified_gmt":"2024-05-24T07:09:46","slug":"add-and-use-formulae","status":"publish","type":"pracctice_guide","link":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/","title":{"rendered":"Add and Use Formulae"},"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>Case Management Supervisors<\/strong> and <strong>System Supervisors<\/strong><\/p>    \n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">This guide will show you how you can add Formulae into Osprey to automatically populate your letters and dossier fields<\/h2>\n\n\n\n<p class=\"is-style-info wp-block-paragraph\">Please note that only Supervisor level users are able to create Formulae.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Navigate to your \u2018Supervisor\u2019 tab and select \u2018Case Management Setup\u2019. Then select the \u2018Formulae\u2019 tab from the resulting menu, as highlighted below.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"568\" height=\"671\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-566.png\" alt=\"\" class=\"wp-image-67531\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-566.png 568w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-566-254x300.png 254w\" sizes=\"auto, (max-width: 568px) 100vw, 568px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Any formulae previously created will be visible here. To add a new formulae, click on the \u2018New\u2019 button at the top of the screen.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The following screen will now appear:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"847\" height=\"509\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-567.png\" alt=\"\" class=\"wp-image-67532\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-567.png 847w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-567-300x180.png 300w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-567-768x462.png 768w\" sizes=\"auto, (max-width: 847px) 100vw, 847px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Formulae can be used to perform mathematics on numeric fields, for example if you wished to add together two numeric dossier fields, you would be able to create a formulae for them and have the result appear in your dossier or in a standard document.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can also use them to join together text fields to prevent duplication of any data. For example, a client\u2019s full name would normally be separated into title, forename and surname. With a formulae, you could have all three display at the same time, which would be useful when adding this data to legal forms and documents.<\/p>\n\n\n\n<p class=\"h2 wp-block-paragraph\">Numeric Fields<\/p>\n\n\n\n<p class=\"is-style-info wp-block-paragraph\">The most common use of the Formula function is to perform sums on chosen numeric dossier fields. Please note that these functions will only work if the dossier field is set as a numeric field \u2013 So either integer or decimal.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">On the \u2018Add Formulae\u2019 screen, enter a Formula Name, which must be a unique name, and a description, as below.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"574\" height=\"247\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-568.png\" alt=\"\" class=\"wp-image-67534\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-568.png 574w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-568-300x129.png 300w\" sizes=\"auto, (max-width: 574px) 100vw, 574px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Underneath the name and description area is the \u2018Filter Fields\u2019 section. This will allow you to select the fields that you would like to be part of your formulae.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"475\" height=\"126\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-569.png\" alt=\"\" class=\"wp-image-67535\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-569.png 475w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-569-300x80.png 300w\" sizes=\"auto, (max-width: 475px) 100vw, 475px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You may take any field from your client or dossier area. Once you have selected the relevant type, use the \u2018Page\u2019 drop-down list to select the location of the field. In our example, we will include two Disbursement fields to add together.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Underneath the \u2018Filter Fields\u2019 area will be the \u2018Formula\u2019 section. This is where you can select a function for your formula, an operator to include a calculation and the fields you would like to include.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"226\" height=\"580\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-570.png\" alt=\"\" class=\"wp-image-67536\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-570.png 226w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-570-117x300.png 117w\" sizes=\"auto, (max-width: 226px) 100vw, 226px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Scroll down the box and double-left click on any functions or fields you wish to include in your formula. These will then be placed into the large formula editor panel to the right of the \u2018Fields\u2019 area. When first added, the fields will just appear as one long string of text as shown in the screenshot below.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"569\" height=\"134\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-571.png\" alt=\"\" class=\"wp-image-67537\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-571.png 569w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-571-300x71.png 300w\" sizes=\"auto, (max-width: 569px) 100vw, 569px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can now add separators between the fields to denote spacing if you wish, or add a function.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this example, we will add our fields together.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Under the \u2018Operators\u2019 area, double-left click the \u2018Add\u2019 option to add a + symbol to the formula.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"225\" height=\"148\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-572.png\" alt=\"\" class=\"wp-image-67538\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can now place the + symbol in between the fields you wish to add together, as shown below.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"564\" height=\"131\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-573.png\" alt=\"\" class=\"wp-image-67539\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-573.png 564w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-573-300x70.png 300w\" sizes=\"auto, (max-width: 564px) 100vw, 564px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This formula will add the present fields together. You can add any other operators you wish, such as Subtract, Multiply or Divide.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To ensure the validity of the formula, there is a \u2018Validate\u2019 button directly under the \u2018Formula\u2019 heading. Select this and you will see one of these two messages:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"645\" height=\"281\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-574.png\" alt=\"\" class=\"wp-image-67540\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-574.png 645w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-574-300x131.png 300w\" sizes=\"auto, (max-width: 645px) 100vw, 645px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you see the \u2018Invalid Formula\u2019 message, then the text in the Formula Editor is incorrect and will need to be amended. The \u2018Formula is Valid\u2019 message advises that the formula is correct and can be used.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can now click the \u2018Save\u2019 option at the top of the screen.<\/p>\n\n\n\n<p class=\"h2 wp-block-paragraph\">Text Fields<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We will use the Client Name as an example. On the \u2018Add Formulae\u2019 screen, enter a Formula Name, which must be a unique name, and a description, as below.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"551\" height=\"241\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-575.png\" alt=\"\" class=\"wp-image-67541\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-575.png 551w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-575-300x131.png 300w\" sizes=\"auto, (max-width: 551px) 100vw, 551px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Underneath the name and description area is the \u2018Filter Fields\u2019 section. This will allow you to select the fields that you would like to be part of your formulae.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"461\" height=\"124\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-576.png\" alt=\"\" class=\"wp-image-67542\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-576.png 461w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-576-300x81.png 300w\" sizes=\"auto, (max-width: 461px) 100vw, 461px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You may take any field from your client or dossier area. Once you have selected the relevant type, use the \u2018Page\u2019 drop-down list to select the location of the field. In our example, the client names are located in the \u2018Linkname\u2019 table, so we will select this.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Underneath the \u2018Filter Fields\u2019 area will be the \u2018Formula\u2019 section. This is where you can select a function for your formula, an operator to include a calculation and the fields you would like to include.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"230\" height=\"578\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-577.png\" alt=\"\" class=\"wp-image-67543\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-577.png 230w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-577-119x300.png 119w\" sizes=\"auto, (max-width: 230px) 100vw, 230px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For a text field, you will only need to select the relevant fields you need from the \u2018Fields\u2019 box. Scroll down the box and double-left click on any fields you wish to include in your formula.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">These will then be placed into the formula editor to the right of the \u2018Fields\u2019 area. When first added, the fields will just appear as one long string of text as shown in the screenshot below. You can now add separators between the fields to denote spacing.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"559\" height=\"131\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-578.png\" alt=\"\" class=\"wp-image-67544\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-578.png 559w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-578-300x70.png 300w\" sizes=\"auto, (max-width: 559px) 100vw, 559px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To separate the fields, you must add the text &amp;&#8217; &#8216;&amp; between each one, as shown in the example below.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"579\" height=\"136\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-579.png\" alt=\"\" class=\"wp-image-67545\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-579.png 579w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-579-300x70.png 300w\" sizes=\"auto, (max-width: 579px) 100vw, 579px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now, you can place any text between the apostrophes which will then be pulled through into the formula. In this example, a space will be added to separate the title, forename and surname.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To ensure the validity of the formula, there is a \u2018Validate\u2019 button directly under the \u2018Formula\u2019 heading. Select this and you will see one of these two messages:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"646\" height=\"277\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-580.png\" alt=\"\" class=\"wp-image-67546\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-580.png 646w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-580-300x129.png 300w\" sizes=\"auto, (max-width: 646px) 100vw, 646px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you see the \u2018Invalid Formula\u2019 message, then the text in the Formula Editor is incorrect and will need to be amended. The \u2018Formula is Valid\u2019 message advises that the formula is correct and can be used.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can now click the \u2018Save\u2019 option at the top of the screen.<\/p>\n\n\n\n<p class=\"h2 wp-block-paragraph\">Using Your Formula<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now that your formula has been validated and saved, you will be able to use it on your dossier pages and standard documents.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Navigate to the Dossier Fields area under the Supervisor &gt; Case Management Setup tab and select the \u2018New\u2019 button at the top of the screen.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Enter a unique field ID and a description, then select \u2018Formula\u2019 from the \u2018Type\u2019 drop-down list. A new drop-down will appear titled \u2018Use Formula\u2019. Here you can select the formulae to link to the dossier field. We will link our Client Name field.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"706\" height=\"344\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-581.png\" alt=\"\" class=\"wp-image-67547\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-581.png 706w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-581-300x146.png 300w\" sizes=\"auto, (max-width: 706px) 100vw, 706px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now click \u2018Save\u2019 to add your new field.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can now add your field to a relevant dossier page as you would with a normal dossier field.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"847\" height=\"178\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-582.png\" alt=\"\" class=\"wp-image-67548\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-582.png 847w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-582-300x63.png 300w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-582-768x161.png 768w\" sizes=\"auto, (max-width: 847px) 100vw, 847px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once added at an appropriate place in your dossier page, the information will be brought through upon accessing the dossier under the Case Management tab.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"785\" height=\"201\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-583.png\" alt=\"\" class=\"wp-image-67549\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-583.png 785w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-583-300x77.png 300w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-583-768x197.png 768w\" sizes=\"auto, (max-width: 785px) 100vw, 785px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A formula can also be added to a standard document without the need to link the relevant dossier field, although you may still do this if you wish.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To simply link the formula, navigate to the Standard Documents area under the Supervisor &gt; Case Management Setup tab. Now right-click on the document you wish to add the formula to and select the \u2018Fields\u2019 option.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">From the \u2018Standard Document Fields\u2019 area, select the \u2018Formula\u2019 radio button.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"479\" height=\"88\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-584.png\" alt=\"\" class=\"wp-image-67550\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-584.png 479w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-584-300x55.png 300w\" sizes=\"auto, (max-width: 479px) 100vw, 479px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now from the list of available formula, tick the box corresponding to the one you wish to add and select the \u2018Save\u2019 button to link the field to the document.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"834\" height=\"237\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-585.png\" alt=\"\" class=\"wp-image-67551\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-585.png 834w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-585-300x85.png 300w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-585-768x218.png 768w\" sizes=\"auto, (max-width: 834px) 100vw, 834px\" \/><\/figure>\n<\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"857\" height=\"348\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-586.png\" alt=\"\" class=\"wp-image-67552\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-586.png 857w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-586-300x122.png 300w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2024\/05\/image-586-768x312.png 768w\" sizes=\"auto, (max-width: 857px) 100vw, 857px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can now add the formula (highlighted above) to your document in the same way that you would add a normal dossier field.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Formulae can be used to perform mathematics on numeric fields and have the result appear in your dossier or in a standard document.<\/p>\n","protected":false},"author":23,"featured_media":0,"template":"","categories":[236],"tags":[],"class_list":["post-2589","pracctice_guide","type-pracctice_guide","status-publish","hentry","category-supervisor-case-management-setup-browser"],"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>Add and use Formulae | Osprey Academy - Customer Support and Training Centre<\/title>\n<meta name=\"description\" content=\"A step-by-step guide to add Formulae into Osprey to automatically populate your letters and dossier 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\/add-and-use-formulae\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Add and use Formulae | Osprey Academy - Customer Support and Training Centre\" \/>\n<meta property=\"og:description\" content=\"A step-by-step guide to add Formulae into Osprey to automatically populate your letters and dossier fields.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/\" \/>\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-05-24T07:09:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-566.png\" \/>\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=\"10 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\/add-and-use-formulae\/\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/\",\"name\":\"Add and use Formulae | Osprey Academy - Customer Support and Training Centre\",\"isPartOf\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-566.png\",\"datePublished\":\"2020-02-13T17:26:03+00:00\",\"dateModified\":\"2024-05-24T07:09:46+00:00\",\"description\":\"A step-by-step guide to add Formulae into Osprey to automatically populate your letters and dossier fields.\",\"breadcrumb\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/#primaryimage\",\"url\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-566.png\",\"contentUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-566.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/#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\":\"Add and Use Formulae\"}]},{\"@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":"Add and use Formulae | Osprey Academy - Customer Support and Training Centre","description":"A step-by-step guide to add Formulae into Osprey to automatically populate your letters and dossier 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\/add-and-use-formulae\/","og_locale":"en_GB","og_type":"article","og_title":"Add and use Formulae | Osprey Academy - Customer Support and Training Centre","og_description":"A step-by-step guide to add Formulae into Osprey to automatically populate your letters and dossier fields.","og_url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/","og_site_name":"Osprey Approach Customer Support &amp; Training | Osprey Academy","article_publisher":"https:\/\/www.facebook.com\/OspreyApproachUK\/","article_modified_time":"2024-05-24T07:09:46+00:00","og_image":[{"url":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-566.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@OspreyApproach","twitter_misc":{"Estimated reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/","name":"Add and use Formulae | Osprey Academy - Customer Support and Training Centre","isPartOf":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/#primaryimage"},"image":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/#primaryimage"},"thumbnailUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-566.png","datePublished":"2020-02-13T17:26:03+00:00","dateModified":"2024-05-24T07:09:46+00:00","description":"A step-by-step guide to add Formulae into Osprey to automatically populate your letters and dossier fields.","breadcrumb":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/#primaryimage","url":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-566.png","contentUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-566.png"},{"@type":"BreadcrumbList","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/add-and-use-formulae\/#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":"Add and Use Formulae"}]},{"@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\/2589","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\/23"}],"version-history":[{"count":3,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/2589\/revisions"}],"predecessor-version":[{"id":67574,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/2589\/revisions\/67574"}],"wp:attachment":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/media?parent=2589"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/categories?post=2589"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/tags?post=2589"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}