9 Replies Latest reply: Aug 25, 2016 5:32 AM by Sunny Talwar RSS

    If Clause is creating Issue in Rangesum

    Mohammad Sarif

      Hi All,


      I need to show rangesum for maxdate in dashboard against Time in X axis in 15 mins interval. And my expression is below:


      RangeSum(Above(Sum({$<Z_DATE=, M_DATE={'$(=(Date('$(vDATE)','M/D/YYYY')))'}>} ORD_LINE_CNT),0,RowNo()))

      vDATE is for max date. For max date we have data till 17:15. Chart is showing data till 17:15. as expected.


      But if we mention below expression then chart is showing data for all time , i.e. till 23:45.


      If (Selector = 'Cum',RangeSum(Above(Sum({$<Z_DATE=, M_DATE={'$(=(Date('$(vDATE)','M/D/YYYY')))'}>} ORD_LINE_CNT),0,RowNo())),0)


      Could anyone please help me on this.


      Thanks in advance for help.