Jump to content

Ad Hoc report IF function does not show terms, only works with numbers


ruben94-7-1

Recommended Posts

I want to create a cross table with terms however the IF expression only works with numbers. Please see working function below:



IF(Contains("Service Type",'Delivery'), 1, IF(Contains("Service Type",'GoParrot - Delivery'), 1, IF(Contains("Service Type",'GoParrot - Take Out'), 3, IF(Contains("Service Type",'Take Out'), 3, IF(Contains("Service Type",'Dine In'), 0, 4)))))



Instead I want to use use terminology rather than numbers:



IF(Contains("Service Type",'Delivery'), ‘Delivery’, IF(Contains("Service Type",'GoParrot - Delivery'), ‘Delivery’, IF(Contains("Service Type",'GoParrot - Take Out'), ‘Take Out’, IF(Contains("Service Type",'Take Out'), ‘Take Out’, IF(Contains("Service Type",'Dine In'), ‘Dine In’, ‘Third Party’)))))



Could the the quotation (') be a factor in the expression?



I hope somone can help me.



Ruben K.


Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...