I have a main report to calculate working hours of employees (known as Equivalent Full Time Employees or EFT)
Working hours for full time employee hours are calculated using formula @EFT.
Working hours for Casual employees are calculated based on different tables so I have a sub-report to calculate and pass back result to main report using a Shared NumberVar @EFTcasual.
All works fine and I get the results back from the sub-report. I also have a formula to calculate @lineTotal = @EFT + @EFTcasual
My problem is that then I cannot get a group subtotals and a grand total of my @lineTotal.
lineTotal does not appear on the list of fields that can be used to create a running total. Also if I create a formula @subTotal = Sum(@lineTotal)
I get error "This field cannot be summarized".
Any ideas on how to solve this problem ?
Thank you