I'm trying to do a calculation similar to this to get a headcount for a specific actives date: if actives date = "11/30/2013" then count employee number else null end however I continue to get an error that I can not complete this calc because actives date is a "date" field and "employee number" is a string (which is correct). I tried changing the data type to string for the actives date demension but that didn't work either. Any help would be greatly appreciated.
There are likely two issues here. First, you cannot use quotation marks to denote a date; you must use # symbols. Second, you cannot aggregate one field while not aggregating another. Try the following formula:
IF [Actives Date] = #11/30/2013# THEN [Employee Number] ELSE NULL END
Now you should be able to add this calculation to your view to get a Count.
I hope this helps,
Dan
