[RESOLVED] Formula problem!!

[conwa02976]

Hi,
I am using Crystal Reports 2008 but I was having the same problem with CR XI also. I looked up past posts and thought I had found a solution but I just can't quite seem to get it worked out. Here are my detail records:

Factor CountofFactor
0 2
1 1
2 0
3 0
4 0
5 0
6 2
7 3
8 14
9 33
10 34

I need three running total formulas. I have two worked out where this is the formula in the Evaluate section:
{vwStmtCounts.Factor} < 7 - gives me a Total of 5 which is correct
{vwStmtCounts.Factor} > 8 - gives me a Total of 67 which is correct

Now I need a formula to give me a total for Factors 7 and 8 combined which would be 17. I've tried variables and it didn't work. My latest version was this:
{vwStmtCounts.Factor} = 7;
{vwStmtCounts.Factor} = 8
I then get 14, so it's easy to see I'm only getting back the last statement which I kinda knew I would.

Any help is greatly appreciated.

Ron

[conwa02976]

Resolved from another forum:
{vwStmtCounts.Factor} IN [7,8]