6 Replies Latest reply: Dec 19, 2017 10:17 PM by Reynaldson Aceberos RSS

    rangesum with 2 dimensions

    Reynaldson Aceberos

      Good Day

       

      i am wondering why my formula is not working properly. i just want to show my data in asset by branch per month,

      when i add the month as a dimension everything seems fine,

       

       

      and this is my formula

      =rangesum( above( Sum({<GLHeader= {1}>} GLTOTAL ),0,rowno()))

      Rangesum went wrong.JPG

       

       

      but when i add the banchname as dimension my data went wrong.

       

      Rangesum went wrong part 2.JPG

       

       

       

      and i dont know why. can someone help me, any help will be appreciated

       

       

      thanks