{"id":23960,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/calculations-related-issue-layouts-1\/"},"modified":"2025-02-12T17:57:19","modified_gmt":"2025-02-13T01:57:19","slug":"calculations-related-issue-layouts-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/relationship-layouts-1\/calculations-related-issue-layouts-1\/","title":{"rendered":"Calculations on Related Issue Layouts"},"content":{"rendered":"

Field Aggregate Expressions (FAE’s) permit calculations to be performed on a per-row basis on Related Issue Displays. The FAE’s are added to fields within a Related Issue Display as layout cell attributes with a type of FIELD AGGREGATE EXPRESSION. There are also custom user exits for retrieval of data, accumulation of results, and the display of results. The display of the accumulated results is generated at the end of each group or collection of rows in a Related Issue Display, as an additional row with a user-defined title. The title is added as a layout cell attribute of type FIELD AGGREGATE EXPRESSION TITLE.<\/p>\n

\n\tCreating and Using a FIELD AGGREGATE EXPRESSION<\/h3>\n

The following are the steps for creating and using a FAE:<\/p>\n

\n\tExample<\/h3>\n
    \n
  1. \n\t\tCreate your Related Issue Display layout and save this in the usual way<\/li>\n
  2. \n\t\tEdit the Related Issue Display layout and select a column to which you want to apply an aggregate function. Click on the link button to add a new layout cell attribute<\/li>\n
  3. \n\t\tChoose the FIELD AGGREGATE EXPRESSION – generate an aggregate value for this row<\/b> entry. Select the appropriate Value for your function from the list – Count, Sum, Minimum, Maximum<\/em> or Average<\/em>. The Use User Custom Code<\/em> value is only valid if you have user custom code in place that will populate the results of the Field Aggregate Expression. See later on this page for details<\/li>\n
  4. \n\t\tThe Field value<\/b> should be set to a number – this will be tied to the FIELD AGGREGATE EXPRESSION TITLE on the Related Issue Display, as well as to the order in which multiple FIELD AGGREGATE EXPRESSION rows should be displayed. It is recommended you start with 1 for the first entry, and increment from there. The number you set must match the number you set in step 7<\/li>\n
  5. \n\t\tSave your changes to the Related Issue Display layout<\/li>\n
  6. \n\t\tNavigate to a parent issue that contains the Related Issue Display and verify the correctness of the results of the aggregate expression you created. It will not have any title or grouping at this moment, but you should see the results of the aggregation<\/li>\n
  7. \n\t\tTo create a title on the Related Issue Display, navigate to the add<\/em> or edit<\/em> layout that embeds the Related Issue Display. On the cell that contains the Related Issue Display, you create an attribute of type FIELD AGGREGATE EXPRESSION TITLE where the Value<\/b> is the Title of the row to be displayed, and the Field value<\/b> should be a number (start with 1). If you have more than one FIELD AGGREGATE EXPRESSION defined on the Related Issue Display, this number is the order in which they will appear. The Field value<\/b> should map to the Field value<\/b> you selected in step 4<\/li>\n
  8. \n\t\tYou can also optionally aggregate values while grouping together values within a field, and providing sub-totals or other attributes for each group. On the add<\/em> or edit<\/em> layout that contains the Related Issue Display, add a layout cell attribute to the Related Issue Display within the layout, of the type RID SORT ORDER. Select the field in the related issue display that you wish to group by, and select Group by<\/b> equal to Yes<\/em>. Now you will generate subtotals as well as a grand total. Clicking on a field title at the top of the related issue display will cause a refresh of the display, change the sort order and the sub-totals<\/li>\n
  9. \n\t\tAgain navigate to your parent issue that contains the Related Issue Display and verify that you now see the title and the optional grouping.<\/li>\n
  10. \n\t\tIn this example, we want to add totals to a Related Issue Display as shown in this screen shot:<\/p>\n

    \t\t
    \n\t\tTotalling a field on a Related Issue Display<\/span><\/p>\n

    \t\tThe key steps are as follows:<\/p>\n

      \n
    1. \n\t\t\t\tOn the Related Issue Display, add the following Layout Cell Attributes to the field that you want to total (HOURS_INCURRED<\/em> in the example). Add a FIELD AGGREGATE EXPRESSION<\/b> with a Value of Sum<\/b> and a Field value<\/b> of 1<\/b>. Save the changes<\/li>\n
    2. \n\t\t\t\tOn the edit<\/em> layout that contains the Related Issue Display, add two additional Layout Cell Attributes. These are in addition to other attributes that most probably exist to provide the RID RELATIONSHIP NAME and other factors for the layout.<\/p>\n
        \n
      • \n\t\t\t\t\t\tRID SORT ORDER – This provides the initial sort order for the display<\/li>\n
      • \n\t\t\t\t\t\tFIELD AGGREGATE EXPRESSION TITLE – This provides the title for the expression. Note that this should be the same value as set in the FIELD AGGREGATE EXPRESSION. The screen for the Layout Cell Attributes will be something similar to the following. Note that only the RID SORT ORDER and the FAE_TITLE pertain to the calculations. The other entries have their own purpose and function.<\/p>\n

        \t\t\t\t\t\t
        \n\t\t\t\t\t\tLayout Cell Attributes for the FAE<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

        This gives the result shown in the screen shot above. Note the initial sort order. Also note that if you click on another field title within the Related Issue Display, there is a re-sort, and the totals for the field are automatically recalculated. This is shown below, where the display is now sorted on the Category<\/em> field.<\/p>\n

        \t
        \n\tResorting the display<\/span><\/p>\n

        \n\tImplementation Notes<\/h3>\n
          \n
        • \n\t\tExpressions will only work with Related Issue Displays that contain 1,000 rows or less, if you implement grouping with aggregate functions<\/li>\n
        • \n\t\tThe Count<\/em> function works on all field types<\/li>\n
        • \n\t\tThe Sum, Average, Minimum and Maximum<\/em> functions work only on numeric display type fields – Number, Decimal and Currency<\/li>\n
        • \n\t\tThe User Custom function requires custom code before it will achieve anything<\/li>\n
        • \n\t\tYou can only group by one column in the related issue display RID SORT ORDER layout cell attribute<\/li>\n
        • \n\t\tYou will get incorrect results if you group on a multi-valued field, or on a repeating record field, for calculations such as Average<\/li>\n<\/ul>\n

          \n\tUtilizing the User Custom Code Exits<\/h3>\n

          This is an advanced topic and it is assumed the administrator is thoroughly familiar with programming within the User Custom Code environment of ExtraView. Please contact ExtraView Support for additional details on how to implement this feature.<\/p>\n

          Setting up field aggregate expressions is similar to the above, but there are a few additional steps.<\/p>\n

          The key step is that the aggregate expression performed in user custom code must be linked to a field on the Related Issue Display. This is achieved by creating a user defined field within the data dictionary, of type Expression<\/b>. This may have any valid display type and will correspond with the returned value from the custom code. This provides your environment with a field name, a display title, security permissions and other attributes. You may have more than one custom aggregate function, with each being linked to a separate user defined Expression<\/b> field.<\/p>\n

          To implement, you provide Java code for the 3 user custom exits for data selection, accumulated value computation and accumulated value display, and compile the code into the user custom class used in the installation.<\/p>\n

          The presence of FIELD AGGREGATE EXPRESSION layout cell attribute in the Related Issue Display layout directs the reporting logic to invoke three FAE-specific custom exits: data selection, value computation, and value display. In addition, the FAE-specific rows are added to the end of the report rows i.e. on the right for transposed Related Issue Displays and on the bottom for non-transposed Related Issue Displays.<\/p>\n

          Each FAE is associated with a specific field in the Related Issue Display, as part of the attributes on the Related Issue Display layout: this defines the row on a transposed Related Issue Display, or the column on a non-transposed Related Issue Display of the FAE result display at the end of the report. There may be more than one FAE associated with a field, resulting in additional columns on transposed Related Issue Displays or rows on non-transposed Related Issue Displays.<\/p>\n

          The three FAE user custom exits are as follows:<\/p>\n

            \n
          1. \n\t\tucFAESelect: called during generation of SQL for the report to permit insertion of SQL into the detail report query for later consumption by the FAE value aggregation. Signature:<\/b><\/p>\n
            \r\n   public String ucFAESelect (\r\n                    SesameSession session,\r\n                    Connection conn,\r\n                    String faeName,\r\n                    String ddName,\r\n                    DetailReportElement re,\r\n                    HashMap distinctTables,\r\n                    String[] locParts,\r\n                    EVHierarchyLevel ehl,\r\n                    HashMap dataAlias,\r\n                    String itemTableAlias,\r\n                    String itemIdKey\r\n   )  throws Exception\r\n<\/pre>\n<\/li>\n
          2. \n\t\tucFAEAggregate: called for each row in the Related Issue Display to permit aggregation of the values in the report \u2013 this could include summation, averaging, or special operations as required. Signature:<\/b><\/p>\n
            \r\n   public void ucFAEAggregate (\r\n                    SesameSession session,\r\n                    Connection conn,\r\n                    String faeName,\r\n                    String ddName,\r\n                    HashMap row,\r\n                    ResultSet resultSet\r\n   ) throws Exception\r\n<\/pre>\n<\/li>\n
          3. \n\t\tucFAEDisplay: called once at the end of the report for each FAE in the Related Issue Display, to allow custom generation of display values for the FAE. Signature:<\/b><\/p>\n
            \r\n   public String ucFAEDisplay (\r\n                    SesameSession session,\r\n                    Connection conn,\r\n                    String faeName,\r\n                    String ddName\r\n   ) throws Exception \r\n<\/pre>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
            Field Aggregate Expressions (FAE’s) permit calculations to be performed on a per-row basis on Related Issue Displays. The FAE’s are added to fields within a Related Issue Display as layout cell attributes with a type of FIELD AGGREGATE EXPRESSION. There are also custom user exits for retrieval of data, accumulation of results, and the display…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":23950,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"no","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-23960","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\nCalculations on Related Issue Layouts - Product Documentation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/relationship-layouts-1\/calculations-related-issue-layouts-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Calculations on Related Issue Layouts - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"Field Aggregate Expressions (FAE’s) permit calculations to be performed on a per-row basis on Related Issue Displays. The FAE’s are added to fields within a Related Issue Display as layout cell attributes with a type of FIELD AGGREGATE EXPRESSION. There are also custom user exits for retrieval of data, accumulation of results, and the display...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/relationship-layouts-1\/calculations-related-issue-layouts-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-13T01:57:19+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/relationship-layouts-1\/calculations-related-issue-layouts-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/relationship-layouts-1\/calculations-related-issue-layouts-1\/\",\"name\":\"Calculations on Related Issue Layouts - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-02-13T01:57:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/relationship-layouts-1\/calculations-related-issue-layouts-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/relationship-layouts-1\/calculations-related-issue-layouts-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/relationship-layouts-1\/calculations-related-issue-layouts-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ExtraView 25\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Administration Guide\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Site Configuration Menu\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Design Center\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"Relationship Layouts\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/relationship-layouts-1\/\"},{\"@type\":\"ListItem\",\"position\":7,\"name\":\"Calculations on Related Issue Layouts\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"contentUrl\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"ExtraView Corporation\"},\"image\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Calculations on Related Issue Layouts - Product Documentation","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:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/relationship-layouts-1\/calculations-related-issue-layouts-1\/","og_locale":"en_US","og_type":"article","og_title":"Calculations on Related Issue Layouts - Product Documentation","og_description":"Field Aggregate Expressions (FAE’s) permit calculations to be performed on a per-row basis on Related Issue Displays. The FAE’s are added to fields within a Related Issue Display as layout cell attributes with a type of FIELD AGGREGATE EXPRESSION. There are also custom user exits for retrieval of data, accumulation of results, and the display...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/relationship-layouts-1\/calculations-related-issue-layouts-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-02-13T01:57:19+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/relationship-layouts-1\/calculations-related-issue-layouts-1\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/relationship-layouts-1\/calculations-related-issue-layouts-1\/","name":"Calculations on Related Issue Layouts - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-02-13T01:57:19+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/relationship-layouts-1\/calculations-related-issue-layouts-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/relationship-layouts-1\/calculations-related-issue-layouts-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/relationship-layouts-1\/calculations-related-issue-layouts-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"ExtraView 25","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":3,"name":"Administration Guide","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/"},{"@type":"ListItem","position":4,"name":"Site Configuration Menu","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/"},{"@type":"ListItem","position":5,"name":"Design Center","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/"},{"@type":"ListItem","position":6,"name":"Relationship Layouts","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/administration-guide-1\/site-configuration-menu-1\/design-center-4\/relationship-layouts-1\/"},{"@type":"ListItem","position":7,"name":"Calculations on Related Issue Layouts"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v25\/#website","url":"https:\/\/docs.extraview.com\/v25\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v25\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v25\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v25\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/","url":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","contentUrl":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","width":512,"height":512,"caption":"ExtraView Corporation"},"image":{"@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v25\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23960","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/comments?post=23960"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23960\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23950"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=23960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}