Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

formula help

Status
Not open for further replies.

OCM

MIS
Sep 12, 2002
220
US

Greetings,

Given the following variables
Hybrid = [Section ID] InList (“65”; "65A”; "S165”; "S265" )
Online = [Section ID] InList (“75" ; "75A" ; "S175" ; "S175A")
Time =If FormatDate( [Start Time] ;"HHmm") >= "1700" Then "Night" ElseIf( IsNull( [Start Time]) ) Then "Other" Else "Day"
I then created another variable called “Type” and made it a detail of {Section ID} as follows:
Type = If [Online] Then "Online" ElseIf [Hybrid] Then "Hybrid" Else “Time”
When I drag this “Type” in my crosstab report, I get #multivalue error. The reason: the same course has multiple start times.

Is there a way to suppress the #Multivalue and display “Multiple start time instead?

Regards,


OCM
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top