I am currently working on a report where I need to count the number of customers where three particular values within an object are present. This is appearing as a header to the report which then lists details about the customers. So far, I have been able to get part of the formula correct but I can’t seem to finish it. I am able to count the customers where the first condition is true but when I try to add the other two, I get syntax error. I am not a programmer and this language is very new to me. Can anyone help me with the following formula.
I need to add “Value2” and “Value3”, and I want to count Company name where has all three values present. Below is what I have so far which works with only one value.
=“Contacts for “&FormatNumber(Count(<Company.Name>) Where (=“Value1” ) ,”#”)&" of"&" “&FormatNumber(Count() ,”#")&" Customers"
Michele Robertson
Southern California Edison
Analyst
Phone: 909-394-8573
Thanks, but I get #COMPUTATION when I try that. Any other suggestions are welcome
From: Debraann Braun[SMTP:Debra.Ann.Braun@FRITOLAY.COM]
Sent: Tuesday, October 13, 1998 1:47 PM
An easy way to do this would be the following:
VariableA
=If InList (“Value1”,“Value2”,“Value3”) then Count <Company.Name>
VariableB
= "Contacts for “” & " of “&” "&FormatNumber(Count() ,‘#’)&“Customers”
Hope that this workes for you,
DebraAnn Braun
Frito-Lay, Inc.
:
I am currently working on a report where I need to count the number of This:
=“Contacts for “&FormatNumber(Count(<Company.Name>) Where (=“Value1”
) ,”#”)&" of"&" “&FormatNumber(Count() ,”#“)&” Customers"
Michele Robertson
Southern California Edison
Analyst
Phone: 909-394-8573
Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
Web archives (9am-5pm ET only): listserv.aol.com/archives/busob-l.html OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
