Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Subject | Jan-2017 | Feb-2017 |
---|---|---|
Maths-1 | 56% | 40% |
Maths-2 | 44% | 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)
Try this,
Sum (Marks) / Sum(Total<Month> Marks)
Regards,
Kaushik Solanki
Hi
Try this
Sum(Marks)/Sum(TOTAL Marks)
Regards
An Pham