Problem getting group sum value
Posted: Thu Nov 05, 2009 2:48 am
Group 1
Group 1-1
Group 1-1-1
--- 100
--- 200
Group 1-1-1 total 300
Group 1-1-2
--- 102.5
--- 103.5
Group 1-1-2 Total 206
Group 1-1 Total : 506
Group 1-2
Group 1-2-1
--- 150
--- 100
Group 1-2-1 total 250
Group 1-2-2
--- 202
--- 303.5
Group 1-2-2 Total 505.5
Group 1-2 Minimum of Group 1-2 : 250
Group 1 Total = Group 1-1 value + Group 1-2 value
I can get the value of Group 1-1 and Group 1-2 but I can't get the value of Group 1 total (which is sum of Group 1-1 and Group 1-2).
It's urgent and I need to submit this report to my boss by next week, please help.
ringo
Group 1-1
Group 1-1-1
--- 100
--- 200
Group 1-1-1 total 300
Group 1-1-2
--- 102.5
--- 103.5
Group 1-1-2 Total 206
Group 1-1 Total : 506
Group 1-2
Group 1-2-1
--- 150
--- 100
Group 1-2-1 total 250
Group 1-2-2
--- 202
--- 303.5
Group 1-2-2 Total 505.5
Group 1-2 Minimum of Group 1-2 : 250
Group 1 Total = Group 1-1 value + Group 1-2 value
I can get the value of Group 1-1 and Group 1-2 but I can't get the value of Group 1 total (which is sum of Group 1-1 and Group 1-2).
It's urgent and I need to submit this report to my boss by next week, please help.
ringo