Formula Field Check if INT

[pmcfarlain]

I want to set up a formula field that can check if a value is an int and if so convert it to an int. How can I verify if a value is an int in the formula is an int? Here's what I tried:

CASE
WHEN ISNUMERIC(RIGHT([@field:Serial_Number], 2))
THEN CONVERT(INT, (RIGHT([@field:Serial_Number], 2)))
END

Any help would be appreciated thanks!

[TellMeWhy]

38 minutes ago, pmcfarlain said:

I want to set up a formula field that can check if a value is an int and if so convert it to an int. How can I verify if a value is an int in the formula is an int? Here's what I tried:

CASE
WHEN ISNUMERIC(RIGHT([@field:Serial_Number], 2))
THEN CONVERT(INT, (RIGHT([@field:Serial_Number], 2)))
END

Any help would be appreciated thanks!

Not sure what the RIGHT is for, you can try this

 

CASE WHEN isNumeric(FIELD) = 1

THEN CONVERT(INT, ROUND(FIELD,0))

ELSE 0

END

it checks if it's numeric (numeric may be INT, Float, etc)

if it is (equal to 1) Then Round the Field to 0 decimal (because INT has no decimal) and convert it to INT(can be omitted, but, just to be sure) to avoid incompatible values when the field's value is in decimal

Else, 0 or any number you want

[NiceDuck]

If you are going to create a case statement, make sure that the return value of all the cases will have the same data type. Otherwise, you may encounter an error during validation.