I'd be grateful for some help. I am using Crystal XI
I am looking to add the results of a formula at Group 2 level together so that I get a total at Group 1 level
The report is set up as follows and I want to add the results of Formula 1 together to give the total $1377.50 at Group 1 level
[Group 1] Project 1A
[Group 2] Rate
Rate FTE Equivilant Cost Formula 1
1a 0.5 $255 $127.50
1b 2.5 $500 $1250.00
Cost of project = $1377.50
Formula 1 is if Cost = 0 then 0 else
Sum (FTE Equivalent}, Rate)*
Maximum (Cost, Rate)
The end result I am after is
Project 1A = $1377.50
Project 1B = $222.50
Project 2A = $2500.00
etc
Thanks
I am looking to add the results of a formula at Group 2 level together so that I get a total at Group 1 level
The report is set up as follows and I want to add the results of Formula 1 together to give the total $1377.50 at Group 1 level
[Group 1] Project 1A
[Group 2] Rate
Rate FTE Equivilant Cost Formula 1
1a 0.5 $255 $127.50
1b 2.5 $500 $1250.00
Cost of project = $1377.50
Formula 1 is if Cost = 0 then 0 else
Sum (FTE Equivalent}, Rate)*
Maximum (Cost, Rate)
The end result I am after is
Project 1A = $1377.50
Project 1B = $222.50
Project 2A = $2500.00
etc
Thanks