MatchInterval in Straight Table AGGR

[#1]

I have student subject and section wise students’ score from which I have calculated Student and its section wise total score.

Score Cal = sum(if(ScoreMax>=StudentScore and ScoreMin <= StudentScore,Score,0))

StudentID	SectionID	SubjectID	Score
1	1	48	10
1	1	49	20
1	1	45	25
1	1	46	25
1	1	47	25
2	1	46	0
2	1	48	10
2	1	45	25
2	1	47	25
2	1	49	25
3	1	46	0
3	1	49	20
3	1	45	25
3	1	47	25
3	1	48	25

TScore Cal = aggr(sum(if(ScoreMax>=StudentScore and ScoreMin <= StudentScore,Score,0)),StudentID,SectionID,SubjectID)

StudentID	SectionID	TScore
1	1	105
2	1	85
3	1	95

I am done till here.

Now I want to grade the students total score. This is separate table

GradeMin	GradeMax	Grade
0	50	Red
51	79	Yellow
80	120	Green

For Grading I want to compare grade max and grade min with total score to grade him. I am stuck with AGGR. Can anyone help? I have to do everything in straight table

[PrashantSangle]

Hi,

Did you try Manish's answer.

It should work.

Regards,

[#3]

I have to work on front end only. Straight table only! Otherwise it was simple to work with single lines

[#4]

any luck?

[#5]

swuehl Gysbert Wassenaartresesco

Please help

[PrashantSangle]

Hi,

It is not possible on your front end..

you have to modify your data model.

Regards,

[#7]

Any suggestion on data model. Keeping in view I have to provide sliders for changing grade min and max and also scoring min and max