Hello, We recently had a situation where an employee was transferred to Taiwan from Hongkong and his credit card balance was paid to the credit card company in Taiwan once he submitted his expenses after his transfer instead of paying it to Hongkong branch. So we are looking to create an audit rule where the system checks for the employee group country and the credit card issuing country to be same before he is allowed to submit the expense report. I hope this clarifies the situation. Thank You

Hello Anna, I was able to create the report. Its a bit complicated report if you are new to Cognos. You need to filter your data to show only the number of expense reports that were processed. The way you can do this is 1. Select all the expense report in your system 2. In the filter prompt, from the workflow trail folder add the following filters to filter your data to only show processer approved expense reports a. [Step Action Date/Time] is not null - this will filter out all the expense report that werent approved b.[Current Workflow Flag (Current = 1)] = 1 - this will only consider expense report that has been worked upon c. [Role Legacy Key] IN ('ACCT_CLERK') - Selects only the expense reports assigned to the processor d. [Employee Assigned to Step] <> 'System, Concur' - Will not select those expense reports that were processed by the system. Once you have your view of the data, you can simply organize it to the way you want to. Hope this will help.

Hi @KevinD , First let me thank you for a detailed response and guide to my question. I appreciate all youe efforts. I understand what you are saying, and I tried with your first solution on Submitted and Not submitted and it works perfectly fine. However I would still like to go ahead and try creating the other two reports that you mentioned will be very complex. I am open to learn, and I would really appreciate if you can guide me or point me to any resources which I can use that can help me develop the other two reports I am looking for. Thank You