I'm working on a report in Crystal 11.5 and need some assistance with a formula. I'm looking at inventory data where the manufacturer is equal to multiple values and the inventory year >= a year or where the manufacturer is equal to other multiple values and the inventory year >= a different year.
Here's what I'm trying. The formula name is {@Exclusions}:
{Inventory.Manufacturer} in ["AAA","BBB","CCC","DDD","EEE","FFF"] and {Inventory.YearEntered} >= 2015 or
{Inventory.Manufacturer} in ["GGG","HHH","III","JJJ","KKK","LLL","MMM"] and {Inventory.YearEntered} >= 2009
Then in my record expert, I want to include:
not {@Exclusions}
Any help would be greatly appreciated and I'm not married to this method if anyone has any better ideas on how to accomplish this.
Thanks!
Here's what I'm trying. The formula name is {@Exclusions}:
{Inventory.Manufacturer} in ["AAA","BBB","CCC","DDD","EEE","FFF"] and {Inventory.YearEntered} >= 2015 or
{Inventory.Manufacturer} in ["GGG","HHH","III","JJJ","KKK","LLL","MMM"] and {Inventory.YearEntered} >= 2009
Then in my record expert, I want to include:
not {@Exclusions}
Any help would be greatly appreciated and I'm not married to this method if anyone has any better ideas on how to accomplish this.
Thanks!