Cell reference in custom transform

Hi! Suppose I have one column (named CV) and one row (content numeric 0.3). If I set a custom transformation in order to assess the content of this cell if(CV<=0.3,'CV<=0.3','CV>0.3')I getA1 <= 0.3Note the reference to the cell (A1) in the result and the leading/trailing blanks inserted around ‘<=’.

Thank you for reporting this problem. This is indeed a problem in PHX1.2 and 1.2.1. The only workaround is to not call something within a text string the same name as the variable that you have mapped. For example, to solve your issue you can type if(CV<=21,“C V<=0.3”,“C V%>0.3”) where there is a blank between C and V within the text string, or rename the variable CV prior to applying the formula. Another workaround is to do 2 column transformations where the first one sets up flags and the second substitutes flags E.g. if(CV<=21,“Flag1”,“Flag2”) (variable Label) if(Label=“Flag1”, “CV<=0.3”, “CV%<0.3”) The spacing problem is still seen with the example above. This defect has been logged, QC 11588. Sincerely, Ana