Hi

I am trying to write a formula to select a specific product and its value for
the current year.
Example: I would call my formula Apples_CurrentYear
Then I want to specify:
if the product = "Apples" it should take the value field where the year field =
2010.

Not 100% sure how to code it in Crystal

Thanks.

Perhaps move this logic to your database query. Consider a parametrized query