4 Replies Latest reply: Sep 26, 2016 6:05 AM by Diana Sarangaya

# How can i eliminate the N/A and re-calculate the total score

Hi Guys,

I need help with my formulas.  I have a

Total Max ScoreActual ScoreScore without NA

5

44

5

55
10N/A0
1066

Total Max = 30 points

Actual Score = 15 points

Score without N/A = 15 points

I want to calculate the percentage of the actual score but instead of calculating it against 30, it should be against 20 since one field is N/A.  How should i do this please?

• ###### Re: How can i eliminate the N/A and re-calculate the total score

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 re-calculate the total score

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.

BRANCHSAMPLE NOFACILITY NOTOTAL MAXACTUAL SCORESCORE WITHOUT N/A
Branch 1sample 1facility 1222
Branch 1sample 1facility 12n/a0
Branch 1sample 1facility 1323
Branch 1sample 1facility 1333
Branch 1sample 2facility 2222
Branch 1sample 2facility 2323
Branch 1sample 2facility 2323
Branch 1sample 2facility 22n/a0

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 re-calculate the total score

Not sure I understand the issue here?

• ###### Re: How can i eliminate the N/A and re-calculate the total score

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.