Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try something like this
subfield(NUMBER,'.',1) as [Before Decimal]
subfield(NUMBER,'.',2) as [After Decimal]
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]