Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to calculate with group fields?

Status
Not open for further replies.

Kretzer

Technical User
Nov 6, 2002
37
0
0
NL
Hi,

so far I did a manual cross table based on groups and it looks like this

Januar Februar March ......
row1 val1.1. val1.2 val1.3

row2 val2.1 val2.2 val2.3

row3 and so on...............

The values are of course group sum fields als all detail fields are invisible.
What I want to do now is to calculate with these values.
For example I want to show in row 4 the result of the calculation of : val2.2*val3.2/val1.2

How can I address the fields correctly so that CR calculates the correct result? I do have big problems adressing a group value of an other group?
I mean, how can I say for a field which is in row (group) 4
take the value of group 1 and group2 and so on...
I always get mistakes...

Hopefully someone can help me.
Thank you

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top