Hi all

 

 

I was wondering if someone could please help me with an IF Statement construction. I need to count the instances where the amount in Table A is greater than 3.5 and less than 4 but they also need to be equal to the Table B values of 39 or 46 or 93 or 95. (just one of these values)

 

 

I have joined an ID in TableA to an ID in Table B as an equal join.

 

 

Something tells me that my if statements is written incorrectly and I was wondering if anyone could please help me to correct  it.

 

I am using crystal syntax and I am pretty new at this.

 

 

 

 

Global NumberVar PlusThreeFivePushBike;

 

 

If {TableA.adlg_drv_units} > 3.5 and {TableA.adlg_drv_units} < 4 or  {TableB.adck_tariff} = "39" or {TableB.adck_tariff} = "46" or {TableB.adck_tariff} = "93" or {TableB.adck_tariff} = "95" then

 

Thanks

 

For the  < 2 values I have tried making it ' >0 and <2' but i still get  a zero.

 

Much appreciated.   

greater than four km

betweeen 3.5 and 4 km

between 3 and 3.5

between 2.5 and 3

between 2 and 2.5

and less than two

 

For formula worked for the four middle criteria but not the 1st and last.

 

 

and they all need to contain one of  the values : '39'  '46'  '93'  '95' from tableB.  

 

Thanks for help here