Hello,
On the attached report I need assistance:
- I have a formula field that I need to display as either " On call or Daily Assignment " if
The call was recieved on a Saturday or a Sunday or
If call is recieved on a friday after 11pm ( = On call)
All else = Daily assignment
The formula I have tried is
If {@DayOfWeek} = "Friday" Then
{@On Call} = 'Voice On Call' or
If {@DayOfWeek} = "Saturday" Then
{@On Call} = 'Voice On Call' or
If {@DayOfWeek} = "Sunday" Then
{@On Call} = 'Voice On Call'
Else
{@On Call} = 'Daily Assignment'
The field is blank when refreshed and how do I incorporate the time criteria into the statement above?