SeedCode Support Forum

I need some help with a calculation, I am needing to count records that are web generated lead and by a specific sales person.

We use FM6. I set up a field Wendy Web Count. I wanted this calculation to enter a 1, then I use a summary to count by date. Example: Wendy did 17 Web quotes on Aug 15 2005.

Case(Sigsphere Contacts::Account Executive = "Wendy" , 1, WebQuoteCounter = "1" , 1 , 1)

Could use some help here.

thanks,

jim shelton wrote:Case(Sigsphere Contacts::Account Executive = "Wendy" , 1, WebQuoteCounter = "1" , 1 , 1)

That's cool, but your calc as written will always return a 1. The following will return a 1 if it was Both by Wendy AND a web quote, returning a zero otherwise:

Case (
Sigsphere Contacts::Account Executive = "Wendy"
and
WebQuoteCounter = "1"
; 1
; 0
)

thanks