how to calculate a total

  • Thread starter Thread starter hermie
  • Start date Start date
H

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
 
hermie said:
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
Click to expand...

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