Hi All
I was working on complex calculation project, where i was confused on logic to be used.
I have matrix which is in Table Like below (Table 1)
Basically i am comparing a list users with this table (Table 2)
I will have user list as below:
Now, I want to compare table 2 with Table 1.
Here is logic:
1. First i will go to User 1 in Table 2, his role is Finance, Now i need to go Table 1, where For Roles Finance, i should not have Requester, Now from Table 2, I need to check if i have any User 1, in my table 2 i have one more User 1 which has Requester. So I need to highlight row with color or some text.
2. Once above done, i need to go User 2 which is in row 2, role is Admin, For Admin, i should not have Finance and Requester. I don't have any other User 2, so ok, no action required.
3. Now last row which is user 1, which has Requester, i need to check in Table 1 for Requester, i don't have any data for Requester, so no action required as well.
I am attaching sample report as well.
Need some assistance here
I was working on complex calculation project, where i was confused on logic to be used.
I have matrix which is in Table Like below (Table 1)
| Roles | Col A | Col B |
| Requester | ||
| Admin | Finance | Requester |
| Finance | Requester |
Basically i am comparing a list users with this table (Table 2)
I will have user list as below:
| Col A | Col B |
| User 1 | Finance |
| User 2 | Admin |
| User 1 | Requester |
Now, I want to compare table 2 with Table 1.
Here is logic:
1. First i will go to User 1 in Table 2, his role is Finance, Now i need to go Table 1, where For Roles Finance, i should not have Requester, Now from Table 2, I need to check if i have any User 1, in my table 2 i have one more User 1 which has Requester. So I need to highlight row with color or some text.
2. Once above done, i need to go User 2 which is in row 2, role is Admin, For Admin, i should not have Finance and Requester. I don't have any other User 2, so ok, no action required.
3. Now last row which is user 1, which has Requester, i need to check in Table 1 for Requester, i don't have any data for Requester, so no action required as well.
I am attaching sample report as well.
Need some assistance here