Forum Discussion
ChrisSipes
6 years agoQrew Cadet
What is the difference between a "report formula" and a "real" formula? These are all summary fields for a summary of items over the course of a week so the formulas do not work on single records in a table. So as I said, I am limited to 3 formulas in a report.
I would gladly summarize over to another table but that is beastly difficult due to the fact that I need a compound key for the summary records and keying off a column in one table destroys the calculations in the field in the first table when it creates the summary table.
It is actually a very simple application, so I would not think it would be so hard.
I have people who log their time during the week. They also indicate the type of time it is which could be regular time, over time, vacation time, double time, night premium time, etc.
I am simply trying to make a report that lists the totals for each category of time for each person. And based on the person and the categories, I will do some calculations to determine their pay.
Instead of one nice report with a column for each type of hours and each amount of pay, the best it will do is to have multiple reports and then I have to copy and paste the data out and tie it back together in a spreadsheet.
I would gladly summarize over to another table but that is beastly difficult due to the fact that I need a compound key for the summary records and keying off a column in one table destroys the calculations in the field in the first table when it creates the summary table.
It is actually a very simple application, so I would not think it would be so hard.
I have people who log their time during the week. They also indicate the type of time it is which could be regular time, over time, vacation time, double time, night premium time, etc.
I am simply trying to make a report that lists the totals for each category of time for each person. And based on the person and the categories, I will do some calculations to determine their pay.
Instead of one nice report with a column for each type of hours and each amount of pay, the best it will do is to have multiple reports and then I have to copy and paste the data out and tie it back together in a spreadsheet.