Calculated field wont allow me to close the brackets
I have created a calculated field and the WHEN calculation wont allow me to close the brackets. It will allow me to save the when-then statement, however the rest of the calculated field fails because of a bracket mismatch.
The structure of the calculated field when it is not letting me add a ")":
( Dimension1 BETWEEN 'X' AND 'Y' AND Dimension2 = XXX ) OR Dimension1 BETWEEN 'XX' AND 'YY' OR Dimension1 BETWEEN 'XXX' AND 'YYY' OR Dimension1 BETWEEN 'XXXX' AND 'YYYY' OR ( Dimension1 BETWEEN 'XXXXX' AND 'YYYYY' AND Dimension1 NOT IN ( 'XXYXX' , 'YXXXX' )
As a workaround I will replace the "NOT IN" with two != conditions however this issue might cause bigger problems later on in different reports.
All the best