formula field not showing up in summary expert

[scottaherbst]

I am working in CR10. I am trying to get a count of clients who met either of two conditions over the year. I have a formula that basically says

If field1 = x
then 1
else if field2 = y
then 1
else 0

There's no problem with the formula; its returning the expected values. The trouble is that when I go to Insert Summary, this formula isn't there. Any ideas?

 

[RoknRole]

Perhaps you could try a Running Total Field instead. Choose the client as the Field to Summarize, select the Type of summary as "Count", select Evaluate - Use a formula and write the formula as "field1 = x or field2 = y", and set Reset as Never (or perhaps to on change of the year).

 

[dgillz]

Please post your entire formula, also indicate where it is on your report.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry