13 Replies Latest reply: Jun 29, 2016 7:01 PM by Peggy Wells RSS

    Expression help -- sum based on 2 criterias

    Peggy Wells

      I want to make a dashboard page that reference the current month always.  I created a table with the header labeled 'Cur Mth' and one row member 'Feb'.  I have the data table with titles Month, Year, Account, Actual Am2.

      sum({$<Year={2016}>,Month={$(Cur Mth)}},[Actual Amt2])

      It says the expression is correct, but I am not getting any data.

       

      If  i use just the year, it works.  sum({$<Year={2016}>}[Actual Amt2])

      I can't get adding the 2nd criteria to work.  Any suggestions.

      What was simple in excel is driving me nuts here.