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