Jump to content
Changes to the Jaspersoft community edition download ×

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


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...