I'm trying to get a report that shows a yearly and quarterly report as shown in the picture:
When I try to calculate the fields I can't get it to add up properly.
field: ActionType ("Process 1", "Process 2", etc)
field: ActionDate (Date of Process)
As an example:
I can perform a find for ActionType = "Process 1" but I can't get it to count the number of 'Process 1" for a quarter.
I was going to use that number to then add all the quarters to use in the Yearly report.
Not sure what I am doing wrong?
The above picture is from a spreadsheet that I transferred all the numbers but I would like Filemaker to do it and skip the step of transferring it.
Any suggestions would greatly be appreciated.