BAQ - Calculated Field Error

Anyone able to code check this?

(CASE 
      WHEN (PartTranStkMtl3.Calculated_StkMtl3 IS NULL) AND (PartTranSale12.Calculated_QtySold IS NULL) THEN 'DISPOSE' 
      WHEN (PartTranStkMtl3.Calculated_StkMtl3 IS NULL) AND (PartTranSale12.Calculated_QtySold > 0) THEN 'OFFER TO TGLPS' ELSE '' 
END)

I’m getting this error

image

Looks error is not from Calculated field case statement, Share your full BAQ to look into it.

1 Like

Found the error.

I added a open bracket to a relationship and didn’t close it.

1 Like