try this calculation for sicK_count :
( attendance_Type = "Sick" ) * Day_lenght
I still get a zero returned, but can I assume that is because my attendance_type="Sick" is a text field? It almost seems like the numerical values I have in day_length (.5 and 1) are not being treated as numbers even though they are defined as a numeric field. Counting the records work, but I cannot perform any mathmatical calculation using that value.
Did you copy exactly my calculation ? ( included both brackets )
( attendance_type="Sick" ) is a boolean calc and should return 1 ( if the field attendance_type contains "Sick" ) or 0
( attendance_type="Sick" )*day_length should return either 0, .5 or 1
Yes, but I think I am still tripping over the day_length field. I have that set to a Value list (1 or .5). I have tried formating it as both general and "Leave Data Formatted as Entered" (under Number Format..). Interestingly enough, even when I make it a straight numeric field, I still cannot get the calculations to work. I am also still a bit unsure how these would all add up the different days off during the year and calculate a total. I don't know if it matters, but I have all the dates (sick, vacation...) that a particular person took off showing up in a portal on the page, and that is why I thought I might use the count feature.
Is the field Day_lenght in the same table of the field attendance_Type ?
Yes, they are both in the same "Attendance" table. THere is a separate table that contains information about each person. Thank you for your continued help, it is greatly appreciated.
I have no more idea on what can be the problem with that calculation...
If you want I can see your file...
Edit: I found two errors. Now it works.