Greetings,
Given the following variables/formulas
Hybrid = [Course Section Number] InList (“65”; "65A”; "S165”; "S265" )
Online = [Course Section Number] InList( "75" ; "75A" ; "S175" ; "S175A")
Time =If FormatDate( [Course Start Time] ;"HHmm") >= "1700" Then "Evening"
ElseIf( IsNull( [Course Start Time]) ) Then "Other" Else "Day"
I then created another variable called “Type” and made it a detail of Course Section ID. Following is the formula:
Type = If [Online] Then "Online" ElseIf [Hybrid] Then "Hybrid" Else “Time”
When I drag this “Type” in my crosstab report, I get # multivalu error. Can you please advise how to get around this error?
TIA,
OCM
Given the following variables/formulas
Hybrid = [Course Section Number] InList (“65”; "65A”; "S165”; "S265" )
Online = [Course Section Number] InList( "75" ; "75A" ; "S175" ; "S175A")
Time =If FormatDate( [Course Start Time] ;"HHmm") >= "1700" Then "Evening"
ElseIf( IsNull( [Course Start Time]) ) Then "Other" Else "Day"
I then created another variable called “Type” and made it a detail of Course Section ID. Following is the formula:
Type = If [Online] Then "Online" ElseIf [Hybrid] Then "Hybrid" Else “Time”
When I drag this “Type” in my crosstab report, I get # multivalu error. Can you please advise how to get around this error?
TIA,
OCM