Using formula macros helps you to expand the capabilities of your Reports and Dashboards, allowing you to add extra functionality or include dynamic content. For example, display current date, display table with custom style sheet or display custom content inside email body.

Formula macro syntax

Switch to HTML mode before adding new macro.

 

Formulas can be executed with syntax as follows: 

{formula}formula content{formula}

Formula content replace with formula that you want to execute inside content.

Formula macro use cases

Displaying current date

{formula}actualDate(){formula}

Displaying indicator value

{formula}M_INDICATOR{formula}

Displaying variable

 {formula}@variable_code{formula}

Displaying custom table

You can also use formula macros to create custom tables like table below. Example of code how to create such a table can be downloaded from here.

 

 

 


  • No labels