Using multiple IF statements in calculated fields

0

I'm trying to create a calculated field in an ad hoc using multiple IF statements. The thing is I'm not sure how to connect the statements. Below are the statements that i'm trying to use.  

IF("Origin Appointment Time" == null, 'NO APPOINTMENT') 

IF(ElapsedHours("Origin Appointment Time", "Origin Arrival Date") < 2,  '< 2 Hours')
 
if(ElapsedHours("Origin Appointment Time", "Origin Arrival Date") > 2,  '> 2 Hours')
 
if(ElapsedHours("Origin Appointment Time", "Origin Arrival Date") > .5,  'ON TIME')
steveo250k's picture
Joined: Jan 7 2012 - 6:29am
Last seen: 3 years 7 months ago

1 Answer:

0

You can next IF functions. Here is a sample with the Foodmart sample data.

 

sfriedman's picture
Joined: Oct 22 2008 - 3:26am
Last seen: 4 years 2 months ago
Feedback
randomness