Forum Discussion

PradipMCT's avatar
PradipMCT
Icon for Resolver II rankResolver II
3 years ago

Why percentage is different

Hi friends,

 

I have a table, shown below:

 

As you see the total percentage is 86.5, however, none of the quarters we have achieved above 65%. Why are these two figures showing different. 

 

the formula used to calculate percentage is as follows:

Adoption % = DIVIDE([Active mgmt CSOD Lrns], [Headcount],0)
 
The formula for Active mgmt CSOD Lrns is: 
Act Mgmt Csod Accessed = CALCULATE([Accessed CSOD],FILTER(csod, CSOD[Final Record Status]="Completed" && CSOD[User status]="Active" && CSOD[Type]="MGMT"))
 
The formula for Headcount is:
Headcount = COUNTROWS('WFA Report')
 
There are two tables here: 1 is CSOD and the other is WFA report table. There is 2 to many relationship between WFA and CSOD table. Here the WFA is the table of all the unique employees in an organisatoin. CSOD is the table where these employees have accessed any online course.
 
HOpe this much information is sufficient to help me. Unfortunately the data is confidential, so i cannot share it. 
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi PradipMCT ,

    In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_Binbin Yu