Nested If statement Issue

[Abhi_WP]

I am trying to derive a dimension called Quarter using below expression but it is not validating. 

= IF([Work Order Completed Code] = {'AC', 'NA'}, [Quarter], If(Len(Trim( [Allocated Quarter] )) > 0, [Allocated Quarter], [Quarter]))

I am trying to achieve - If Work order is completed (AC, NA) then use 'Quarter' field, else if 'Allocated Quarter' field is not null then use 'Allocated Quarter' field else use 'Quarter' field.

[Abhi_WP · Accepted solution]

Managed to solve the issue. Changed the statement to 

= IF(match([Work Order Completed Code], 'AC', 'NA'), [Quarter], If(Len(Trim( [Allocated Quarter] )) > 0, [Allocated Quarter], [Quarter]))

Thanks