Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Best ideas to make a case that uses text and numbers


LivinSports

Recommended Posts

I have special pricing for a few select customers. Therefore, each customer falls into a certain category.

 

I am trying to create a case statement to alter the pricing for the invoice when it is entered.

 

For instance...John Q Deli receives a .30 cents discount on item 111 from 1/10/05 until 1/17/05

 

What I did was create

 

Case ( t_Item_Store_Category = "John Q" and

Delivery Day ≥ Special Price Start Day and

Delivery Day ≤ Special Price End Day;

Selling Price = John Q Special Price;

Selling Price )

 

I was told you can't use numbers and text in the same case. What would be the best solution?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.



×
×
  • Create New...

Important Information

Terms of Use