Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try with
If(IsNull(
Before(ProductionContribution,1)
) ....
thanks so much!