Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FIELD CAN NOT BE SUMMARIZED

Status
Not open for further replies.
maddur31

maddur31

ISP
Feb 18, 2005
7
0
0
US
Hello,

I created an If Then Formula where it displays a "yes" and
"NO" if a condition is met "YES" HOW CAN I COUNT THE YES.
IF {3OD}=0 AND
{60D}=0 THEN
"YES".
Thanks
Maddur
 
Sort by date Sort by votes
Change the formula or create a second formula:

IF {3OD} = 0 AND
{60D} = 0 THEN 1

Then right click on this formula->insert summary->choose "sum" (NOT "count").

-LB
 
Upvote 0 Downvote
Or do a running total that uses the test as a conditional formula.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SarahSCPDAdmin
  • Locked
  • Question
Can I format data in a memo field? 1
Replies
5
Views
101
SarahSCPDAdmin
SarahSCPDAdmin
Cpreston
  • Locked
  • Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
83
Cpreston
Cpreston
Tichaona
  • Locked
  • Question
Row numbering formula not working
Replies
4
Views
101
lbass
lbass
jchewsmith
  • Locked
  • Question
Formatting an embedded field in Crystal 2016 Support Pack 5 1
Replies
3
Views
95
BobSuruncle
BobSuruncle
AleXSR700
  • Locked
  • Question
How can I make variable that is re-defined per section and readable in same-section formula? 2
2
Replies
20
Views
271
AleXSR700
AleXSR700

Part and Inventory Search

Sponsor

Back
Top