AnsweredAssumed Answered

Question on filling field in FileMaker Pro 11

Question asked by Indy14 on Oct 29, 2010
Latest reply on Oct 29, 2010 by Indy14

Title

Question on filling field in FileMaker Pro 11

Post

I have a field that is labeled Quantity. At the present time I have it filled as a calculation

Quantity=

Case(

Product ID = 1; Length*Width;

Product ID = 2; Length*Width;

Product ID = 3; Length*Width;

Product ID = 4; Length*Width;

Product ID = 5; Length+Width;

Product ID = 20; Length*Width;

Product ID = 12; "1";

Product ID = 6; "1";" ")

It was working fine until I needed to manually enter a Quantity if the Product ID was = to a 12 or 6 and not have it as a 1.

I don't know how to change the definition.

Any help would be appreciated.

Outcomes