1 Reply Latest reply: Oct 28, 2013 12:08 PM by Tresesco B RSS

    Even if we use set analysis in our expression it will show wrong values..

      Fiends,

      I have have an expression to calculate the cumulative total based on the isoWeek selection. We have list-box to select the isoWeek.

      The below the expression have been working for some scenario. In some ceases not working.

      When zooming the portion of the area in the charts which is showing wrong values. How to make the zoom to work correctly with set analysis?

      Ceil((Aggr(RangeSum(Above(Sum({$<isoWeek=>}[A]), 0, RowNo())), isoWeek)) / (Aggr(RangeSum(Above(Sum({$<[isoWeek]=>} [B]), 0, RowNo())), isoWeek))*100,0.01)

       

      Kindly help me resolve the problem.

       

      Regards...

      Thiru.