Can't Summarize

[SAWB]

I am trying to count the # of SKUs that have sales of over 36 pc. I have this formula in a group footer:
EvaluateAfter (Sum ({@Total}, {tItems.Size})) ; if Sum ({@Total}, {tItems.Size}) > 36 then 1 else 0

CR8 won't let me sum this formula.

Any ideas?

 

[triad66]

Have you thought about using a running total instead? You could increment the running total only when qty exceeds 36.

 

[kenhamady]

You can't sum a field that does a summary operation unless you use variables to create a running total. See the FAQ on running totals and use the 3-formula technique. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.