One of the user created below variable and he mentioned that this column is displaying #MULTIVALUE

[Nagshiva]

Hi All,

One of the user created the below variable and he reported that this column is returning #MULTIVALUE.

=If( [MTO Line OTIF - YTD].[DSC Shipping (AOM)] = "649" And Max( [MTO Line OTIF - YTD].[Ship Date (line)] ) In ( [MTO Line OTIF - YTD].[Order Number Line Number] ) > Min( [MTO Line OTIF - YTD].[Ship Date Requested - Reported] ) In ( [MTO Line OTIF - YTD].[Order Number Line Number] ) ) Then "Late"
ElseIf( [MTO Line OTIF - YTD].[DSC Shipping (AOM)] <> "649" And [MTO Line OTIF - YTD].[Change Reason Code] ="6"And Max( [MTO Line OTIF - YTD].[Ship Date (line)] ) In ( [MTO Line OTIF - YTD].[Order Number Line Number] ) > Min( [MTO Line OTIF - YTD].[Ship Date Requested - Line] ) In ( [MTO Line OTIF - YTD].[Order Number Line Number] ) ) Then "Late"
ElseIf( [MTO Line OTIF - YTD].[DSC Shipping (AOM)] <> "649" And [MTO Line OTIF - YTD].[Change Reason Code] <> "6" And Max( [MTO Line OTIF - YTD].[Ship Date (line)] ) In ( [MTO Line OTIF - YTD].[Order Number Line Number] ) > Min( [MTO Line OTIF - YTD].[Ship Date Requested - Line Original] ) In ( [MTO Line OTIF - YTD].[Order Number Line Number] ) ) Then "Late"
Else "On-Time"

I have noticed that even though this variable is a measure it is returning character values resulting #MULTIVALUE.

Is there any way to fix this issue?

Regards
Siva

[nachtaktiv]

This variable cannot be a measure because the different results of the formula are text.
Try to simplify your formula to find the problem instead of just copying all the user's work into the question-box.