4 Replies Latest reply: Oct 3, 2017 5:52 AM by Aniruddhya Dutta RSS

    Range sum function in expression

    Aniruddhya Dutta

      Hi All,


      I have an expression which is working fine to calculate the cumulative and non cumlative sum of a measure as below


      if (SELECTOR1='CUM',

      RangeSum(Above(Sum(Documents_Produced), 0,  RowNo())),Sum(Documents_Produced))


      Now I just changed the expression to take distinct proc ids while evaluating the document produced which is not working


      if (SELECTOR1='CUM',

      RangeSum(Above(sum(Count({$<Documents_Produced={'1'}>} distinct PROC_ID), 0,  RowNo())


        Sum(Count({$<DATE={'$(vDATE)'},Documents_Produced={'1'}>} distinct  PROC_ID)))



      can some one plz help?