Getting sum from field with validation from another field.

[BL Splash]

I need to pull sums of fields. I need it to split out to two different sum fields. What i want it to do is if the value of "games played" field is "JV" then it pulls the value from those fields to give a total in "Point total JV", if it sees "V" in that same field (games played), then it takes those values and give the sum in "Point total V". I was thinking of having the same calc in both fields (Point Total JV/V), just looking at the "games played" field for validation.

 

If I make any sense or possible, does anyone have any ideas? If you need further clarification, please ask.

 

Blake

[dj]

Originally posted by Blake L:

[qb]I need to pull sums of fields. I need it to split out to two different sum fields. What i want it to do is if the value of "games played" field is "JV" then it pulls the value from those fields to give a total in "Point total JV", if it sees "V" in that same field (games played), then it takes those values and give the sum in "Point total V". I was thinking of having the same calc in both fields (Point Total JV/V), just looking at the "games played" field for validation.

 

If I make any sense or possible, does anyone have any ideas? If you need further clarification, please ask.

 

Blake[/qb]

i'll try something like this:

 
pointTotals, summary field
and
pointTotalsSplitted calc field:
getSummary(pointTotals,ganesplayed)

of course you'll need to do sort on "games played" to actually see it works

 

HTH

 

Dj

[BL Splash]

DJ,

 

Thank you for the reply, could you clarify a little on your response...I was trying some stuff with your suggestions, but still not seeing the result...I also wanted to say that the values pulled together in the point totals are from repeating fields...does that make a difference?

 

blake