Curious why this won't work...

I'm simply looking to make a status field empty if a product field contains any of the 4 options.

If(lu_IDProduct=

"SVC.DeKD" or

"SVC.AsCP" or

"SVC.AsDL" or

"SVC.DLIn"

,

"" ,

"Back Ordered")

If (Iu_IDProduct = "SVC.DeKD" or 

Iu_IDProduct = "SVC.AsCP" or 

Iu_IDProduct = "SVC.AsDL" or 

Iu_IDProduct = "SVC.DLIn"; ""; "Back Ordered")

You have to redefine what it is equal to each time.



Alternatley you could do 

Let([

a = Iu_IDProduct];



Case(

a = "SVC.DeKD"; "";

a = "SVC.AsCP"; ""; 

a = "SVC.AsDL"; ""; 

a = "SVC.DLIn"; "";

"Back Ordered"))

The second way is how I would do it, incase I ever need to change things. Say when the product ID = SVC.DeKD I decided to make that "In Inventory"

I would change:

a = "SVC.DeKD"; "";

to

a = "SVC.DeKD"; "In Inventory";

If(lu_IDProduct= "SVC.DeKD" or

lu_IDProduct="SVC.AsCP" or

lu_IDProduct="SVC.AsDL" or

lu_IDProduct="SVC.DLIn"

,

"" ,

"Back Ordered")

Try:

Case (

IsEmpty ( FilterValues ( "SVC.DeKD

Edited August 2, 200520 yr by Guest

I don't understand what your saying there.

The way i see your calculation is

If it DOESN'T (the not comment) equal any of those, then make it equal "Back Ordered" and thats it?

And that will return nul value for everything else?

Man do I feel like a bonehead now.

I been doing that forever. But I didn't realize you could just throw a not( in there like that.

I don't understand what your saying there.

Yes, you do - you have explained it better than I ever could.

Try:

Case (

IsEmpty ( FilterValues ( "SVC.DeKD