Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
baarathi
Creator III
Creator III

How to get % for the following

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)

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Try this,

Sum (Marks) / Sum(Total<Month> Marks)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
kenphamvn
Creator III
Creator III

Hi

Try this

Sum(Marks)/Sum(TOTAL Marks)


Regards

An Pham