18 Replies Latest reply: Jun 19, 2017 4:24 PM by Vishwarath Nagaraju RSS

    Error - Expected ')'

    Alexander Roos

      Hello,

       

      I'm struggling to identify where the error is occurring in the following expression:

       

      =Month(max(Date)) & ' vs ' & Month(max(Date)-31) & chr(10) & 'Spending' & chr(10) &

      num(fabs($(vMonthSpending) - $(vLastMonthSpending) / $(vMonthSpending)), '(##.00%)')

       

      I'm trying to get a text output of a selected month vs. last month's spending increases as a percentage.

       

      Here is the expression for the Year vs. Last Year spending increase that executes successfully:

       

      =max(Year) & ' vs ' & (max(Year)-1) & chr(10) & 'Spending' & chr(10) &

      num(fabs($(v2017Spending) - $(v2016Spending) / $(v2017Spending)), '(##.00%)')

       

      Any advice or assistance is much appreciated.

       

      Best,

      AR