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

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

    Diana Sarangaya

      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?