1 Reply Latest reply: Dec 15, 2017 7:36 AM by Sunny Talwar RSS

    Cumulative sum went wrong

    Reynaldson Aceberos

      Hi good day to every one. im trying to create a Balance Sheet->Asset  visualization where in it can be view by branch per month. so i use this formula.


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

      Rangesum went wrong.JPG


      but when i add another dimension for the branch... the data went wrong,

      Rangesum went wrong part 2.JPG


      it and i dont know why i happens. can someone help me to correct my computation and visualization. and i am new in Qlik Sense.