I'm stack with syntax, trying to write a nested IIf function with an omitted false part.Can anybody tell me what actually I'm doing wrong:
IIf ([0505 Q TotalDaysDiscrepantNoComment].[Datediff_1] < [0506 Q TotalDaysDiscrepantWComment].[DateDiff_2],"True Returned/Implanted"),
IIf ([0505 Q TotalDaysDiscrepantNoComment]. [Datediff_1] > [0506 Q TotalDaysDiscrepantWComment]. [DateDiff_2]),"Was counted After it was Returned/Implanted"),
IIf ([0505 Q TotalDaysDiscrepantNoComment]. [Datediff_1] = [0506 Q TotalDaysDiscrepantWComment]. [DateDiff_2]),"Research")
Thank you in advance!
Valeriya
IIf ([0505 Q TotalDaysDiscrepantNoComment].[Datediff_1] < [0506 Q TotalDaysDiscrepantWComment].[DateDiff_2],"True Returned/Implanted"),
IIf ([0505 Q TotalDaysDiscrepantNoComment]. [Datediff_1] > [0506 Q TotalDaysDiscrepantWComment]. [DateDiff_2]),"Was counted After it was Returned/Implanted"),
IIf ([0505 Q TotalDaysDiscrepantNoComment]. [Datediff_1] = [0506 Q TotalDaysDiscrepantWComment]. [DateDiff_2]),"Research")
Thank you in advance!
Valeriya