I'm trying to create a manual crosstab report with two groups at the left and a known number of years on the top. Grouping and summaries are working fine, but I can't get my formula right. I'm assuming that I create a formula for each year and place in the Details section. Here's what's not working:

first year formula
if {AssetYear.Value}) = {Revision.planyear} then
{AssetYear.GetEndingValue}
second year formula
if {AssetYear.Value}) = {Revision.planyear} + 1 then
{AssetYear.GetEndingValue}

Any ideas? Thanks!

Eric,
     I'm not sure it will help but the obvious thing to me is that in neither of your formulas do you have an "else" statement.
      e.g. if {AssetYear.Value}) = {Revision.planyear} then {AssetYear.GetEndingValue} else 0
      Also you have a closed bracket after {AssetYear.Value} but no opening bracket.
      Hope this helps,

      narooma