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
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