Hello
I am running CRXI and want to know how to do this. There has to be a way.
I am trying to create a report to determine projected earnings for employees and departments.
I have a formula derived on an employee grouping called Projected Earnings.
I have another grouping for departments. To me, this sounds like a pretty simple sum function.
However, when I attempt Sum ($({@projearnings})), I get an error msg: "field is required here." It must be me; there has to be a way to do this.
In case it helps, this is my formula for projearnings:
(Sum ({CMDEMPLOYEEPRTIME.WAGE-AMOUNT}, {CMDEMPLOYEEPRTIME.EMPLOYEE})*365)/DateDiff ("d",#1/1/2007#, CurrentDate)
Anyone?
Thanks.
I am running CRXI and want to know how to do this. There has to be a way.
I am trying to create a report to determine projected earnings for employees and departments.
I have a formula derived on an employee grouping called Projected Earnings.
I have another grouping for departments. To me, this sounds like a pretty simple sum function.
However, when I attempt Sum ($({@projearnings})), I get an error msg: "field is required here." It must be me; there has to be a way to do this.
In case it helps, this is my formula for projearnings:
(Sum ({CMDEMPLOYEEPRTIME.WAGE-AMOUNT}, {CMDEMPLOYEEPRTIME.EMPLOYEE})*365)/DateDiff ("d",#1/1/2007#, CurrentDate)
Anyone?
Thanks.