bcartwright
IS-IT--Management
Hello All,
I have created a macro that successfully calculates Overtime as a % of Gross for each Department by using the SumField$ command and a groupo level of 1 (There is only one group level in my report) by defining two variable a and b (See bottom of post) and then dividing a / b.
My problem is that I created a 2nd macro to do the same thing for the report total (Entire Report Group). I cannot get this to work. I've tried several options in the group level, including 0 and 2, but nothing seems to work. Any help would be appreciated.
Brian.
a=Val(SumField$("TOT_OT","Derived Field",1,"Sum"))
b=Val(SumField$("CHECKVIEWGROSSPAYA","V_CHK_VW_EARNINGS",1,"Sum"))
i
I have created a macro that successfully calculates Overtime as a % of Gross for each Department by using the SumField$ command and a groupo level of 1 (There is only one group level in my report) by defining two variable a and b (See bottom of post) and then dividing a / b.
My problem is that I created a 2nd macro to do the same thing for the report total (Entire Report Group). I cannot get this to work. I've tried several options in the group level, including 0 and 2, but nothing seems to work. Any help would be appreciated.
Brian.
a=Val(SumField$("TOT_OT","Derived Field",1,"Sum"))
b=Val(SumField$("CHECKVIEWGROSSPAYA","V_CHK_VW_EARNINGS",1,"Sum"))
i
