{"id":3745,"date":"2016-07-13T03:00:35","date_gmt":"2016-07-12T19:00:35","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3745"},"modified":"2019-10-14T16:18:15","modified_gmt":"2019-10-14T08:18:15","slug":"formula-form","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2016\/07\/13\/formula-form\/","title":{"rendered":"What is Formula Form?"},"content":{"rendered":"<p>Formula form can be understood as a complex data dictionary used for switching actual value and display value.<br \/>\nIn this article, we will introduce formula form of FineReport <a href=\"http:\/\/www.finereport.com\/en\/\" target=\"_blank\"><span style=\"color:blue;\">business intelligence<\/span><\/a>.<\/p>\n<h3>1. Overview<\/h3>\n<p>Actually, formula form in <a title=\"FineReport BI and reporting tool report designer\" href=\"http:\/\/www.finereport.com\/en\/features\/report-designer\" target=\"_blank\">report designer<\/a>can be understood as a complex data dictionary used for switching actual value and display value.<\/p>\n<p>In the example below, the database has stored a column of date data in \u201cyyyy-MM-dd\u201d format. However, to display them in report, we need to change them to \u201cEnglish month abbreviation-dd\u201d (e.g., from 2009-01-03 to Jan-01). In this case, we need to use formula form as it cannot be realized through data dictionary.<\/p>\n<p>The effect is as shown below:<\/p>\n<p><img class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201607111.png\" alt=\"\" \/><\/p>\n<p><img class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201607112.png\" alt=\"\" \/><\/p>\n<p>Right click date cell and select Form | Formula Form. Set formula <span style=\"color: purple;\">=value(&#8220;ds2&#8221;, 2, 1, mid($$$, 6, 2), 1) + &#8220;-&#8221; + mid($$$, 9, 2)<\/span>.<\/p>\n<p>value formula meaning: Make the second column in data set ds2 &gt; display value (2) and first column &gt; actual value (1). Compare the actual value with the cut-out current value ($$$), and change the matching actual value to display value. Then, combine the two-digit date obtained in the current value (which indicates number of days) to obtain a display value meeting the requirements. As shown below:<\/p>\n<p><img class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201607113.png\" alt=\"\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Formula form can be understood as a complex data dictio&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[117],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3745"}],"collection":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/comments?post=3745"}],"version-history":[{"count":5,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3745\/revisions"}],"predecessor-version":[{"id":8284,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3745\/revisions\/8284"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=3745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=3745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=3745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}