How to count amount the word Sick days are in my database
I am quiet new with Filemaker pro and I did the web pages training but I have not found the solution for how many sickdays are reported in a month.
I am making a montly time tracking database for a client and give on Tuesday a demo.
I would be great if you can help me how to solve this.
I have a field called (days type) where employees can fill in of it is normal working day sick days and vakation days.Of course on a monthly base the cusomer need to knwo how many sick days and holidays are ( can be graphic)
It would be great if you can give me a detailed example ( I olny need copy and paste) to solve this
issue. I worked with "word coun"t and with If (days type= sick days);1;0
and the count sick days
but both solutions are not working.
Is there an command that counting the words that you can defined
count amount (Sick Days; days type)
I cannot tell which is the name of your quantity field. Anyway, try this ...
Calculation called cDaysSick (result is number ) with:
Case ( DaysType = "Sick" ; SickDays )
... where SickDays is your quantity field and "Sick" is the value that gets put into the DaysType field - adjust as needed. Then create a summary field which is 'Total of cDaysSick'