Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys, is there any other function to use which applies the same function as Before() function but will not display null value?
In the before function, use an expression (like RangeSum) that does not return null values. Like:
=before(RangeSum(Sales))
-Rob
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 )
)
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 ))
)
It still give me null value 😐