3 Replies Latest reply on May 2, 2018 2:25 AM by Jyothisree Rayagiri

    Previous months as 0 in a running sum across the table

    Smeet Patel

      Hi All,

       

      I am looking for a workaround to get the running sum across a table for a calculated field for various development months.

      As seen in the below image,i want to dislpay "0" in the blank data for month "9"  i.e the previous value as 0 when null and not for all blank/nulls.

      The current definition is:-

      iif(Sum([Number of Records])>=1,

      (running_sum(ZN([Calculated Field]))),Null)

       

      Appreciate your efforts in advance.