Sum If greater or less in Classes

[TestUser152]

Hello everybody, I need your help.

I have a record with project name, their value and a percentage.

Now I want to divide the whole into classes (see table).

Class	Percentage
A	1
B	>0,9
C	0,9< >0,75
D	0,75< >0,50
E	<0,5

The respective class "D" should then sum up all projects that have a percentage between 75 and 50 percent. The result should look like in the table.

Class	Projectname	Percentage	sum(Value)
A		1	500000
	AB	1,00	250000
	CD	1,00	250000
B		>0,9	340000
	DF	0,95	113333
	EA	0,90	113333
	GG	0,97	113333
C		0,9< >0,75	300002
	AD	0,80	150001
	SD	0,89	150001
D		0,75< >0,50	201244
	XX	0,60	201244
E		<0,5	100000
	Q	0,10	100000

I wanted to show it in a ValueList and implement it with Sum IF and so on. However, I just can not get the class division.

(=IF(ValueList('A','B','C,'D','E') = 'C', sum(if([Percentage] >0,75 or [Percentage]<0,9, [Value]))…….)

The whole I would then want to show in a bar chart.

Thanks for your help.

[Vegar]

try:

ProjectTrans:
LOAD * inline [
Projectname,Percentage,Value
AB,1,250000
CD,1,250000
DF,0.95,113333
EA,0.9,113333
GG,0.97,113333
AD,0.8,150001
SD,0.89,150001
XX,0.6,201244
Q,0.1,100000
];

Class:
LOAD * inline [
Class, 	Percentage_from,Percentage_to
A,		1,				1
B,		0.9,			0.999999
C,		0.75,			0.899999
D,		0.5,			0.749999
E,		0,				0.499999
];

left join(ProjectTrans)
IntervalMatch (Percentage)
LOAD Percentage_from,Percentage_to
Resident Class;
Drop field Percentage_from;