https://community.qlik.com/t5/QlikView/Get-Post-with-null-in-ODD/m-p/1759977#M453989 <P>Yes you can, the ODD() function is a boolean function that only evaluates integers, meaning it will return NULL if you try to evaluate decimals.</P><P>You can simply use the following expression to change to outcome:</P><P>if(ODD(&lt;insert number field&gt;)=-1, 3,1) AS OddNumber</P><P>in natural language: If the number I want to evaluate is an odd number, you're returning the value -1 for true, if that's the case, give me three instead, if it's not give me 1.</P> Mon, 09 Nov 2020 17:23:54 GMT Martijn_W 2020-11-09T17:23:54Z https://community.qlik.com/t5/QlikView/Get-Post-with-null-in-ODD/m-p/1759800#M453983 <P>Hi, i got a calculation with odd function that gives me -1 or 0 if it's even, but i want to have this null values, can i set some value, like 3 if it's odd in script?</P><P>Even get me null and even gets me -1 or 1</P><P>&nbsp;</P><P>&nbsp;</P><P>Br</P> Mon, 09 Nov 2020 11:07:36 GMT https://community.qlik.com/t5/QlikView/Get-Post-with-null-in-ODD/m-p/1759800#M453983 johnan 2020-11-09T11:07:36Z https://community.qlik.com/t5/QlikView/Get-Post-with-null-in-ODD/m-p/1759977#M453989 <P>Yes you can, the ODD() function is a boolean function that only evaluates integers, meaning it will return NULL if you try to evaluate decimals.</P><P>You can simply use the following expression to change to outcome:</P><P>if(ODD(&lt;insert number field&gt;)=-1, 3,1) AS OddNumber</P><P>in natural language: If the number I want to evaluate is an odd number, you're returning the value -1 for true, if that's the case, give me three instead, if it's not give me 1.</P> Mon, 09 Nov 2020 17:23:54 GMT https://community.qlik.com/t5/QlikView/Get-Post-with-null-in-ODD/m-p/1759977#M453989 Martijn_W 2020-11-09T17:23:54Z