5 Replies Latest reply: Jan 3, 2017 9:14 AM by Adam Davies RSS

    Importing and expanding $variables

    Adam Davies

      I am having a mind blank....

       

      I want to store some calculations in excel/DB and then import them, basically to create a custom report format in a pivot table

       

      All of the expressions are already in variables.

       

      The upload spreadsheet for example is:

          

      _ReportLevel_ReportHeading_ReportCalculation_ReportFormat
      sWeekly Profitability
      Issued$(v_exp_jobinvoicedcount)#,##0
      Value$(v_exp_jobinvoicedvalue)£#,##0;-£#,##0
      Avg Value$(v_exp_jobinvoicedvalue) / $(v_exp_jobinvoicedcount)£#,##0;-£#,##0
      aWeek Average £#,##0;-£#,##0

       

      What syntax do I then need to use to calculate the relevant variable if _ReportHeading is the dimension?