2 Replies Latest reply: Dec 19, 2014 6:18 AM by Dermot mcgoldrick RSS

    Current Month % Of Total

    Dermot mcgoldrick

      I have a straight table showing top 10 values by a dimension for the current month.  This works fine :

       

      sum({<Year={$(=year(today()))},MonthNum={'$(=upper(Month(today())-1))'}>}Value)

      I want to then work out the % of the current month for each of the lines, trying to use this but it only returns 100% ?  :

       

      sum({<Year={$(=year(today()))},MonthNum={'$(=upper(Month(today())-1))'}>}Value)/sum({$<Year={$(=year(today()))},MonthNum={'$(=upper(Month(today())-1))'}>}Value)

       

      Any idea where I am going wrong?