My Stuff
Default Avatar
See All the Unlockable Badges See All the Unlockable Badges

Dan Abate Newbie

Comments

  • following your case when statement.. here's how it should be, given that your fields are correct.. CASE WHEN {quantityavailable} > 0 THEN 'In Stock' WHEN NVL({quantityavailable},0)<=0) AND ( NVL({quantityonorder},0)<=0) THEN 'Out of Stock' WHEN (NVL({quantityavailable},0)<=0) AND ({quantityonorder} > 0) THEN 'Pending…
    in 100 Ways to Use Formula Fields Comment by Dan Abate Oct 5, 2012 4:53PM
  • Hello, I am trying to create a custom item field called "Stock Status" that assigns free-form text values based on inventory levels for that item. The logic for this field is clear in my head, however, I have very little experience (i.e. no) experience in scripting or creating formula fields using SQL expressions. I have…
    in 100 Ways to Use Formula Fields Comment by Dan Abate Sep 7, 2012 3:40PM