4 Replies Latest reply on Dec 4, 2011 7:42 AM by Tom_Droz

Calculations

Is it possible to use two qualifiers in a case statement?

Case ( BendSchedules::BundleType = "Crossed" & RowCount = 1 ; BendRadiusRowA ;

BendSchedules::BundleType = "Crossed" & RowCount = 2 ; BendRadiusRowA ;

BendSchedules::BundleType = "Crossed" & RowCount = 3 ; BendRadiusRowB;

BendSchedules::BundleType = "Standard" & RowCount = 1 ; BendRadiusRowA ;

So I need two things true in order for it to calculate. Is that the best way to handle it?

Right now it does not seem to be working.

Thanks,

Jason

• 1. Re: Calculations

Hi Jason,

Yes it is, use the reserved word “and” in your calculation like so….

Case( BendSchedules:BundleType = “Crossed” and RowCount = 1; whatever)

Tim

• 2. Re: Calculations

'&' is the same as 'and' and will fail in your case statement.

Ron

• 3. Re: Calculations

Sorry, my bad! '&' and NOT the same as 'and' and will fail in your case statement.

Ron

• 4. Re: Calculations

Case (VEHICLES::Fuel Type ="None" and VEHICLES::Weight > 0 ;"Yes"; "No")

Here is an example that work

If 'Fuel type'  is "None"  and Weight is greater than zero

result  =Yes

Otherwise = No