2 Replies Latest reply: Jan 31, 2018 1:40 AM by An Pham RSS

    How to get % for the following

    Baarathi V
      SubjectJan-2017Feb-2017
      Maths-156%40%
      Maths-244%60%

       

       

      Here, I have two subjects maths-1 and maths-2, both for 100 marks each. But I need to a calculation like this, maths1/(maths1+maths2)[Jan-2017], I tried using the following expression. But I show result as 100% both, I want to get sum of maths1 and maths2 to be 100%

       

      = Sum(Marks)

      / ((Sum({<Subject= {'Maths-1}>}

                Marks)

      + (Sum({<Subject= {'Maths-2'}>}

               Marks)