If and Case functions

[TDebb8594]

quote:

---

Originally posted by LiveOak:

Check the field types for all your fields. Also the calculate field should have type set to "number". -bd

---

It is still not working. My Type and Billable? fields are both text. My monthly cost field is "calculation"

Is this right?

[TDebb8594]

I am working on the Mac version, 5.0. I can't seem to make the functions work.

The field I am working in is called "Monthly cost". The monthly Cost varies first on wether or not it is Billable. If the "Billable?" field says "no" than the monthly cost is $0. If "yes" than the following variables apply: If the "Type" field says "system" than the monthly cost is $133.33. The default is $33.33.

AS the instructions say, I go to define fields and enter

Case (Billable?="no", 0, Type="System", 133.33, 33.33.

This function shows no results at all.

Does anyone know what I am doing wrong?

Thanks

[LiveOak]

Check the field types for all your fields. Also the calculate field should have type set to "number". -bd

[Vaughan]

Try using a combination of If and case functions:

If (Billable?="no", 0,

Case (Type="System", 133.33,

33.33))

[LiveOak]

Your calculation field has a pull-down in the dialog to assign a type to the result. Make sure this is set to "number". Also, what do you mean by "no result"? Does this mean a blank result?

If you are still having trouble, send me a copy of the file. -bd