Replacing Before() function

[#1]

Hello guys, is there any other function to use which applies the same function as Before() function but will not display null value?

[rwunderlich]

In the before function, use an expression (like RangeSum) that does not return null values. Like:

=before(RangeSum(Sales))

-Rob

[#3]

It dont work. Take a look at my code?

=if( Before( Sum (IF(Status <> 'SINGLE' and GUYS>=0, GUYS,0)) , 0)  = 0

  OR IsNull( Before( Sum (IF(Status <> 'SINGLE' and GUYS>=0, GUYS,0)) , 0)) = -1, null(),

if( MonthLast( MAX( Date ) ) <> var_LastDate AND MonthLast( MAX ( Date ) )

= MonthLast( var_LastDate ) ,

                Sum( IF(Status = 'ATTACHED', GUYS,0)) / Day( var_LastDate ) * Day(MonthLast( MAX ( Date ) )) ,

                Sum( IF(Status = 'ATTACHED', GUYS,0) ))

                - Before(Sum(IF(Status = 'ATTACHED',GUYS,0)) , 1 )

                )

[Kushal_Chawda]

ty this,

f( Before( Sum (IF(Status <> 'SINGLE' and GUYS>=0, GUYS,0)) , 0)  = 0

  OR IsNull( Before( Sum (IF(Status <> 'SINGLE' and GUYS>=0, GUYS,0)) , 0)) = -1, 0,

if( MonthLast( MAX( Date ) ) <> var_LastDate AND MonthLast( MAX ( Date ) )

= MonthLast( var_LastDate ) ,

                rangesum(Sum( IF(Status = 'ATTACHED', GUYS,0)) / Day( var_LastDate ) * Day(MonthLast( MAX ( Date ) ))) ,

                rangesum(Sum( IF(Status = 'ATTACHED', GUYS,0) ))

                - Before(Sum(IF(Status = 'ATTACHED',GUYS,0)) , 1 ))

                )

[#5]

It still give me null value 😐