If Before xx = (not there) do this....

[Anonymous]

On the first column using a Before there would be no value.  In this case, i want to do a different calculation but I cant determine how to check if there is nothing 'before'.    Any clues?

If (Before(ProductionContribution,1) =  (there is no before row....  how  do I say this in an If statement)

  ,((([Prod Prior To WAH]) - ProductionContribution) / [Prod Prior To WAH]),

    ((Before(ProductionContribution,1) - ProductionContribution) / Before(ProductionContribution,1))

)

Thanks

MA

[alexandros17 · Accepted solution]

try with

If(IsNull(

Before(ProductionContribution,1)

) ....

[Anonymous]

thanks so much!