2 Replies Latest reply: Sep 29, 2016 12:29 PM by Sunny Talwar RSS

    Replace null values with 0 through expression

    Rakesh sharma

      Want to Replace null values with 0 through expression .

       

      It has two dimensions and for second dimension some values are missing.

       

      Need accumulated value from April to Max month.

       

      Below is the expressions  -

      =Aggr(Rangesum(Above((Count({<Attr_Flag={1},Year={'$(vMax_Year)'},[Month ID]={'<=$(vMax_MonthID)'}>}DISTINCT [Employee Code])),0,RowNo())),Level,Month)

       

      MonthLevelYTD Attrition Count
      AprManager-
      MayManager1
      JunManager2
      JulManager5
      AugManager-
      SepManager-5
      OctManager-
      NovManager-
      DecManager-
      JanManager-
      FebManager-
      MarManager-