Showing total count of assignments of a work object
Hi ,
I have a requirement where I need to show total assignments count in Report.
I have created 2 joins for Assign-WL and Assign-WB for Work class and in columns using prefix.
I am able to show count of WL.pyAssignmentStatus count and WB.pyAssignmentStatus count.
It is working properly, But I want to show the total of both WB and WL assignments in one column (TotalOpenTasks)
Could you please let me know for any solution.
Thank you,
Tulasi
Cognitonic Systems Australia
AU
@TulasiKCCan you try below approach:
Create two sub reports which return the count of open tasks that are in Assign-WorkList and Assign-WorkBasket and use that value in the main report with aggregate function Add. Pass the count value that is obtained from both the sub reports to Add function as input.
Updated: 2 Dec 2021 22:33 EST
Cognizant
IN
Thanks for the reply.
I created one sub report to fetch count of WL and WB assignments using class joins.
And then used those count columns of Sub report in main report and gave them as input to Add function.
Working as expected.
Thank you
Tulasi