0 Replies Latest reply on Jun 12, 2018 1:26 PM by jameelj

    Calculations on report created using bip using rtf template


      I am creating my first BIP report. I am using RTF template to build this.


      My question here is can I do the calculations like total revenue = income1 + income2  or net margin = income - expense on the report level rather than doing at the datamodel level.


      My sample dataset query result is


      Queryid     Date     Amount

      income1     June     125

      income2     June     75


      field browser value is set to

      <?for-each:G_1?><?if:QUERY_ID='income1'?><?Amount?><?end if?><?end for-each?>


      Request someone to share some info on this..