{"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:\/\/www.finereport.com\/en\/product-functions\/formula-form.html","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 dictionary used for switching actual value and display value. In this article, we will introduce formula form of FineReport business intelligence. 1. Overview Actually, formula form in report designercan be understood as a complex data dictionary used for switching actual value and display value. In the&#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],"yst_prominent_words":[2174,2173,2166,2168,2167,2161,1035,2172,2165,2175,185,2169,2177,2176,2164,2163,2170,2160,2171,2162],"_links":{"self":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3745"}],"collection":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/comments?post=3745"}],"version-history":[{"count":4,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3745\/revisions"}],"predecessor-version":[{"id":8284,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3745\/revisions\/8284"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=3745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=3745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=3745"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=3745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}