Forum Discussion

damit23183's avatar
damit23183
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

Average formula

Hi,   Need help with AVERAGE formula,   I would like to calculate below condition,   ID                   ServiceName        %Value     --> Column Name 1                             A         ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi damit23183 ,

    Could you please mark this post as Answered since the problem has been resolved by yourself? Thank you.

     

    Best Regards

    Rena

damit23183's avatar
damit23183
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Hi,

 

Thanks for quick response.

 

So far data are correct just drilldown option is not working on page.

 

Result are not expected when i select any service it keep getting same number but SCORE should change if i choose any particular service. For example; please see expected result below;

Service Name%Value
AAMI0.87
CUG0.85
PUG0.84
AURORA0.81
Total Average0.83

 

As you can see above total average is 0.83 so i am only getting 0.83 whenver i select any service.

But, i would like to see 0.87 when i select AAMI and 0.81 when i select AURORA.

Hope this will enough detail however if you need more please let me know.

Thanks