This works fine, but I also need to add another criteria into the if statement.. When I add it in I start to get All the other CostLevels with 0's in, and I only want to see L1s (is in $3). This can be seen in the attachments
The new statement is like this:
IF('$1'='Actual' AND (AsOfPeriod <= $(vProdCutOff)),
so, it's not when a second constraint is added - it is when I try to constrain based on a non parm field... is that how it works? Does it not do it row by row? I can't refer to information outside of the calc?