nested Sum if

Options
Archanatiwari
Archanatiwari Member, ALL USERS, Partner Posts: 2 New Contributor
in Planning & Modeling

Hi, 

I need to get total of selected roles occurrence which can fall in three different categories. For example, among all the users , I need to count how many users have role of ADM, and then  if they had the same role 3 months ago also- If yes it will be counted in No change list ( Category 1) and if their role is changed, It will be counted into new role (category 2 ) and third is the new  users who have no history 3 months ago ( Category 3). Following is the screen shot 

Archanatiwari_2-1650864553669.png

 

Following is the data table 

Archanatiwari_1-1650864469461.png

Can some one please guide me how can I achieve it. I tried using Sum if function  when role was not changed and it gives me following error 

Archanatiwari_4-1650864760967.png

 

Thanks 

 

 

 

Tagged:

Comments

  • Archanatiwari
    Archanatiwari Member, ALL USERS, Partner Posts: 2 New Contributor

    Thanks for replying Manjunath, I was able to achieve the solution using COUNT function in place of Sum. 

Categories