It might sound really stupid but it is requirement of the client(. We have grouping by Shift (worked at first half or second half of the day). Please have a look at attached design image 1. in Shift group footer band. There is inner grouping by employee (Data.empNo column). We should sum only one value from each employee in Shift group footer band. The desired result is in image 2(and wrong summing in image 3)
There is duplication in employee data (comes from Database). For each employee only one value row should be shown (image 2). Currently, we are summing by doubleField is our field in Shift group footer band.
Code: Select all
$"{{(SumIf({doubleField}, {doubleField} != -9999999))}}";
How can we exclude repeating value in Sum. I mean How can we sum in Shift group footer band. So it will be calculating based on only one row from employee AND summing values from several employees (image 2).
If it is can be done only be event please mention what event should be used for that [should be considered as The undesired and final solution]. And please add code snippet please
Regards,
Iskandar
Regards,
Iskandar