Calculation Not Working

General support questions.
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm
PostPosted: Mon Mar 13, 2006 2:48 pm
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, :oops:
JIMBO
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Mon Mar 13, 2006 3:08 pm
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
)
John Sindelar
SeedCode
PostPosted: Mon Mar 13, 2006 7:54 pm
thanks

Return to General Support

Who is online

Users browsing this forum: No registered users and 2 guests

(855) SEEDCODE
[email protected]
Follow us: