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