this year and last year as a variable

If you use an If statement then the variable you reference has to be in the block. If you use Sum() Where(…) then you do not have to include the year as part of the block.

There is a FAQ entry on how to use a variable in the Where(…) portion of that formula.


Dave Rathbun :us: (BOB member since 2002-06-06)