{"id":203,"date":"2022-06-09T19:37:08","date_gmt":"2022-06-09T19:37:08","guid":{"rendered":"https:\/\/docs.xlreport.com\/?post_type=docs&#038;p=203"},"modified":"2022-06-14T18:04:39","modified_gmt":"2022-06-14T18:04:39","slug":"expression-and-formulas","status":"publish","type":"docs","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/expression-and-formulas\/","title":{"rendered":"Expression and Formulas"},"content":{"rendered":"<h2>Add an Expression<\/h2>\n<ul>\n<li value=\"1\">Add expressions &#8211; formulas by double clicking the Table column or by selecting <span class=\"DoIt\">Expression <\/span>in the Table column.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/28.png\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/29.png\" \/><\/p>\n<ul>\n<li value=\"1\">Enter an expression either manually or by double clicking the appropriate field and operator.<\/li>\n<\/ul>\n<p class=\"note\">Note! XLReport will allow to enter any expression supported by the database you are connected to.<\/p>\n<ul>\n<li value=\"1\">Click <span class=\"DoIt\">Ok <\/span>and the expression will be added.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/30.png\" \/><\/p>\n<h2>Expressions &#8211; Date Function<\/h2>\n<p>In process&#8230;<\/p>\n<h2>Convert Expressions<\/h2>\n<p>In process&#8230;<\/p>\n","protected":false},"featured_media":0,"parent":147,"menu_order":5,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/203"}],"collection":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/comments?post=203"}],"version-history":[{"count":1,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/203\/revisions"}],"predecessor-version":[{"id":204,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/203\/revisions\/204"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/147"}],"next":[{"title":"Aggregate Functions","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/aggregate-functions\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/209"}],"prev":[{"title":"Define Sorting","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/define-sorting\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/199"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=203"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}