MAX & MIN 1

[reidtw]

Hi, using cr8 and sql2k db.

Can't seem to get this right: -

I have two groups 1. SecId, 2. Deal Type

Deal Type has two values B or S

I need to return the minimum price amount for B in group footer for SecId but unsurprisingly it's not working!

I have the following formulas: -

GH2
//@Price_Min_Reset
whileprintingrecords;
numbervar Price01:=0;

Detail
//@Price_Min
whileprintingrecords;
numbervar Price01;
Price01:= if {DealType} = "B" then minimum({@PRICE},{DealType});

GF1
//@Price_Min_Display
whileprintingrecords;
numbervar Price01;

Because Deal Type "S" is always after "B", zero values are returned for it and the display formula is always zero, I can't seem to populate with the correct value.

What am I not doing? I've tried running totals, the lot to no avail!

Some help would be great.
Trevor

 

[IdoMillet]

One option is to create a Running Total with a formula of Type = B to control what records are evaluated.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

Use the running total as Ido suggested, or change your detail formula to:

whileprintingrecords;
numbervar Price01;
if {DealType} = "B" and
(
onfirstrecord or
{@PRICE} < Price01
) then
Price01 := {@Price};

-LB

 

[reidtw]

Thanks for your input both of you, I plumped for the running totals on the correct group and it worked fine!

Thanks again,
Trevor