How to get clean integer values?

[Draxl_Andreas]

Hello,

for any reason, i can`t get an empty value to cero… because for any reason it is a string…
so i multibly the “empty string” by 1 and i get null and i can replace it by 0…

is there a better way ? when i get integers i expect to work with integers… it seems to be it is not always the way…

KR

Andreas

[christian.stan]

hello, it is still possible to create a function as well

function:

def transform_int(a)
{
return a==""?0:Math.Floor(a);
};

cordially
christian.stan

[Draxl_Andreas]

@christian.stan ,

i tried this also and it works… hmmm

[christian.stan]

to create trouble in the mind

cordially
christian.stan

[jacob.small]

I would use the simple if statement here as it is the most robust and least susceptible to data type errors (ie, if you get ‘one’ as a value instead of 1). The design script is as posted by @Draxl_Andreas: x==“”?0:x;