calc based off value list

[devinh]

I've need some direction! I need to find the sq footage used.

I've got three fields.

Plate_type(Value List) and

Plate_Count (number filed)

Total_sqft (calulation)

The Value list is popup list that allows the users to select the plate used. each plate type has a known sqft. but I need away to instert into the calculation the sqft # for the used plate type.

237=7

840=8

If Plate_type was 237

the calc would be.

7xPlate_count

if the Plate_type was 840

8xPlate_count

Thanks

Devin

[devinh]

Well I got something to work with a test calculation using if, but I've got 8 more plate types to add. But I don't think this is a good solution since later we could add more plates and that would require a change to the calc.

Devin

[Lee Smith]

Try a case instead of an If Statement, and see if that helps.

Case(

Plate_type = 237 ; Plate_count * 7 ;

Plate_type = 840 ; Plate_count * 8 ;

Plate_type = 123; Plate_count * 9)

HTH

Lee

[devinh]

Great that is better!

Thanks

Devin