Hi,
I have a derived field set up to take the annual rate and times it by certain numbers. I want to then take that total and I want it to just give me the first three digits in the thousands place.
For example, if the derived field returns anywhere between 1,000 and 9,999 I want it to return the first digit (1-9). If it returns 10,000 - 99,000 I want it to return the first two digits (10-99). And if it returns anywhere between 100,000 and 999,999 I want it to return the first three digits (100 - 999). (Or basically I want it to drop anything to the right of the coma.)
I have tried RTRIM, RPAD, etc and I can't get any of it to work. So any suggestions would be great.
I am using oracle.
Thanks in advance for your help.
I have a derived field set up to take the annual rate and times it by certain numbers. I want to then take that total and I want it to just give me the first three digits in the thousands place.
For example, if the derived field returns anywhere between 1,000 and 9,999 I want it to return the first digit (1-9). If it returns 10,000 - 99,000 I want it to return the first two digits (10-99). And if it returns anywhere between 100,000 and 999,999 I want it to return the first three digits (100 - 999). (Or basically I want it to drop anything to the right of the coma.)
I have tried RTRIM, RPAD, etc and I can't get any of it to work. So any suggestions would be great.
I am using oracle.
Thanks in advance for your help.