Interge and Decimal

[#1]

how do you get the whole number and then the decimal?

Example: 1500.90

I want only what is before the point and then just what is the point after.

Result: 1500

Result: 90

thank you

[goldnejea8]

Try something like this

subfield(NUMBER,'.',1) as [Before Decimal]

subfield(NUMBER,'.',2) as [After Decimal]

[goldnejea8]

And if you need to make sure it is still a number after the fact, you could try something like this:

num(subfield(NUMBER,'.',1),'# ##0,#') as [Before Decimal]

num(subfield(NUMBER,'.',2),'# ##0,#') as [After Decimal]