replace a value to NA when it is greater than -100

[Darmesh]

Hi,

i need to replace a value to NA when it is greater than -100.

 i tried a this expression but throwing error.

row5.Adjusted_PAT_Rs_m_YOY_3>="-100"?"NA":row5.Adjusted_PAT_Rs_m_YOY_3

or

row5.Adjusted_PAT_Rs_m_YOY_3>=-100?"NA":row5.Adjusted_PAT_Rs_m_YOY_3

[TRF · Accepted solution]

Use this expression
Integer.parseInt(row5.Adjusted_PAT_Rs_m_YOY_3)>= -100 ? "NA" : row5.Adjusted_PAT_Rs_m_YOY_3