{"id":3094,"date":"2019-03-25T17:42:40","date_gmt":"2019-03-25T20:42:40","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/performing-mathematical-operations-between-columns-in-a-report\/"},"modified":"2020-01-23T10:13:25","modified_gmt":"2020-01-23T13:13:25","slug":"performing-mathematical-operations-between-columns-in-a-report","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/","title":{"rendered":"Performing mathematical operations between columns in a report."},"content":{"rendered":"<div align=\"justify\">\n<p><b>Questions:<\/b><\/p>\n<p>How can mathematical operations between two or more columns in a report be performed?<\/p>\n<p><b>Solution:<\/b><\/p>\n<p>Reports are generated from handling and including <b>Text <\/b>and <b>Data Field<\/b> objects into PageHeader, Detail, and\/or PageFooter sections. The column printed in a report shows the results from filling the <i>DataField <\/i>property of a Data Field inserted in a Detail section. This property will establish what will be queried from the Database, and how this information will be presented in the report. Therefore, to perform mathematical operations between columns in your report, just write the desired formula in <i>DataField <\/i>property and the result will be displayed in the respective Data Field.<\/p>\n<p>The example below shows you how to add two values between a report&#8217;s column:<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4775\/Figura%201.png\" alt=\"\" width=\"325\" height=\"47\" align=\"Baseline\" border=\"0\" \/><\/div>\n<\/div>\n<h3 style=\"text-align: left;\" align=\"center\">Attachments:<\/h3>\n<p><a href=\"\/wp-content\/uploads\/2019\/03\/Sample-2.zip\">Sample<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Questions: How can mathematical operations between two or more columns in a report be performed? Solution: Reports are generated from handling and including Text and Data Field objects into PageHeader,&hellip;<\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[761],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Performing mathematical operations between columns in a report. - Elipse Knowledgebase<\/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:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Performing mathematical operations between columns in a report.\" \/>\n<meta property=\"og:description\" content=\"Questions: How can mathematical operations between two or more columns in a report be performed? Solution: Reports are generated from handling and including Text and Data Field objects into PageHeader,&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:42:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-23T13:13:25+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4775\/Figura%201.png\" \/>\n<meta name=\"author\" content=\"Gabriel Manara\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gabriel Manara\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/\"},\"author\":{\"name\":\"Gabriel Manara\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/62f73726da552619d723db2fd82e3530\"},\"headline\":\"Performing mathematical operations between columns in a report.\",\"datePublished\":\"2019-03-25T20:42:40+00:00\",\"dateModified\":\"2020-01-23T13:13:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/\"},\"wordCount\":134,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"Reports\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/\",\"name\":\"[:pt]Performing mathematical operations between columns in a report.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:42:40+00:00\",\"dateModified\":\"2020-01-23T13:13:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Performing mathematical operations between columns in a report.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/62f73726da552619d723db2fd82e3530\",\"name\":\"Gabriel Manara\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8f08450bea42667090b5d00999160306?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8f08450bea42667090b5d00999160306?s=96&d=mm&r=g\",\"caption\":\"Gabriel Manara\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/manara\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Performing mathematical operations between columns in a report. - Elipse Knowledgebase","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:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]Performing mathematical operations between columns in a report.[:] - Elipse Knowledgebase","og_description":"Questions: How can mathematical operations between two or more columns in a report be performed? Solution: Reports are generated from handling and including Text and Data Field objects into PageHeader,&hellip;","og_url":"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:42:40+00:00","article_modified_time":"2020-01-23T13:13:25+00:00","og_image":[{"url":"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4775\/Figura%201.png"}],"author":"Gabriel Manara","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Gabriel Manara","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/"},"author":{"name":"Gabriel Manara","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/62f73726da552619d723db2fd82e3530"},"headline":"Performing mathematical operations between columns in a report.","datePublished":"2019-03-25T20:42:40+00:00","dateModified":"2020-01-23T13:13:25+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/"},"wordCount":134,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["Reports"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/","url":"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/","name":"[:pt]Performing mathematical operations between columns in a report.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:42:40+00:00","dateModified":"2020-01-23T13:13:25+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/performing-mathematical-operations-between-columns-in-a-report\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Performing mathematical operations between columns in a report."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/62f73726da552619d723db2fd82e3530","name":"Gabriel Manara","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8f08450bea42667090b5d00999160306?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8f08450bea42667090b5d00999160306?s=96&d=mm&r=g","caption":"Gabriel Manara"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/manara\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3094"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=3094"}],"version-history":[{"count":3,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3094\/revisions"}],"predecessor-version":[{"id":9961,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3094\/revisions\/9961"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=3094"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=3094"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=3094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}