cumulative view in a pivot

[RobMazaheri]

trying to get a cumulative view in a pivot using the below statement but its not working. someone has advised that if there is a 0 then the formula cannot see past this ? is this correct and if so how do i get around his ??

RangeSum (Above (

SUM(

{<

    COMMISSIONING_RCVD_DT ={">=01/04/2023"}

    >}SUBMITTED_THP)

,0,RowNo()))