Thanks for the update Venky,
I tried to create a var, and sum the values using the following formula:
whileprintingrecords;
shared NumberVar RTotal;
If {Command.SUM(WRKD_MINUTES)}= 1 and {Command.UNIT} > '0:00' Then
RTotal :=
ToNumber ({Command.UNIT})
else If {@Grouping_5}='Casual Loading 22.5%' Then
RTotal :=
SUM ({@OA_Wrk}, ({Command.EMPLOYEE_HISTNAME}))-SUM ({@OA_PS},({Command.EMPLOYEE_HISTNAME}))
ELSE
RTotal :=
{Command.SUM(WRKD_MINUTES)};
I then called the value by:
whileprintingrecords;
shared numbervar RTotal;
The problem is that I still need to group by the description of the codes returned and display the summed value that relates to the description
Any help would be greatly appreciated
Regards,
Despina