how to calculate a total

[hermie]

Hello
in the footer of my report i made a calculated textbox
=IIf([tipotarea]="1",Sum([points])) this works but shows the total of all
points. What I want is only the total of point where tipotarea is 1
e.g.
tipotarea points
1 23
1 29
1 32
2 45
2 39
So in my case i like that the calculated field show 84 and not 168
Is this possible?
herman

 

[Rick Brandt]

Hello
in the footer of my report i made a calculated textbox
=IIf([tipotarea]="1",Sum([points])) this works but shows the total of
all points. What I want is only the total of point where tipotarea is
1
e.g.
tipotarea points
1 23
1 29
1 32
2 45
2 39
So in my case i like that the calculated field show 84 and not 168
Is this possible?
herman

=Sum(IIf([tipotarea]="1",[points],0))