This content has been marked as final.
Show 4 replies

Re: How can i eliminate the N/A and recalculate the total score
Sunny Talwar Apr 21, 2016 11:11 AM (in response to Diana Sarangaya)May be this:
Sum({<[Actual Score] = {'N/A'}>}[Actual Score])/Sum({<[Actual Score] = {'N/A'}>} [Total Max Score])

Re: How can i eliminate the N/A and recalculate the total score
Diana Sarangaya Sep 21, 2016 3:04 AM (in response to Sunny Talwar )Hi Sunny,
I have another question. It's similar to my previous question. i have been using the formula you gave me for almost every calculation that i have.
BRANCH SAMPLE NO FACILITY NO TOTAL MAX ACTUAL SCORE SCORE WITHOUT N/A Branch 1 sample 1 facility 1 2 2 2 Branch 1 sample 1 facility 1 2 n/a 0 Branch 1 sample 1 facility 1 3 2 3 Branch 1 sample 1 facility 1 3 3 3 Branch 1 sample 2 facility 2 2 2 2 Branch 1 sample 2 facility 2 3 2 3 Branch 1 sample 2 facility 2 3 2 3 Branch 1 sample 2 facility 2 2 n/a 0 i used the formula you gave me, Sum({<[ActualScore] = {'N/A'}>}[ActualScore])/Sum({<[ActualScore] = {'N/A'}>} [TotalMax]) and added filter pane in my dashboard for the sample number and facility number but it's not giving me the desired result.
I hope you can help me again.

Re: How can i eliminate the N/A and recalculate the total score
Sunny Talwar Sep 21, 2016 11:48 AM (in response to Diana Sarangaya)Not sure I understand the issue here?

Re: How can i eliminate the N/A and recalculate the total score
Diana Sarangaya Sep 26, 2016 6:05 AM (in response to Sunny Talwar )it's alright. i was able to solve the problem. there was something wrong with my data that's why i'm not getting the correct result. Thanks anyway.


