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

    Icon

    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