Specify Groups in Formula

[JKW777]

Hi -

I have a report made up of several subreports that follow the following format:

Subreport 1
MONTH $ UNITS
GROUP1
(Group 2) Product A $ 50 10
(Group 2) Product B 100 20
(Group 2) Product C 200 15
(Group 2) Product D 25 5
------ -------
GROUP1 TOTAL $175 50

Subreport 2 MONTH $ UNITS
GROUP1
(Group 2) Product A $ 10 15
(Group 2) Product B 120 30
(Group 2) Product C 400 20
(Group 2) Product D 30 25
------ -------
GROUP1 TOTAL $560 90
(Product is an account, so each group 2 is a range of accts)

What I need to do is create another subreport (same format) that does the following for each row (example: Prod.A):

(Sub2 $ + (Sub1 $/Sub1 Unit) * Sub2 Unit)
10 + ( 50 / 10 ) * 15

My problem is that I don't know how to specify the individual groups (and their account ranges)in my formula.
Any ideas would be appreciated.

Thank you.

 

[Madawc]

Please clarify. What's the basis for the data in the two subreports? And what version of Crystal?

If it is details from two different records, you could use a formula field to get data from one or the other. And then group using the formula field.

Madawc Williams
East Anglia, Great Britain