topic Re: Negative values with sign in App Development

Negative values with sign

YanivZi — Mon, 08 Aug 2022 13:05:55 GMT

I am loading some values that are formed like that: '-0000000151515' and some like this '0000000151515'.

The values with the minus sign are interpreted in the model like this: 151515M (and sometimes other capital letters)

I like to do this:

I've tried

Num#(Sample, '0;0-') as Amount2

but it did not worked

luizcdepaula — Mon, 08 Aug 2022 13:26:54 GMT

Hi Yaniv,

If you don't have decimals with 0 before the decimal separator, the below should work.

REPLACE(num(LTRIM(REPLACE(Sample, '0',' '))),' ', '0')

Cheers,

Luiz

Aurelien_Martinez — Mon, 08 Aug 2022 13:34:32 GMT

Hi,

If you try

Sample*1 as Sample

Aurélien

YanivZi — Wed, 10 Aug 2022 13:15:09 GMT

Both answers were right! but @Aurelien_Martinez solution was very simple and do the same job.