functions

veera24 · Post by **veera24** » Tue May 06, 2008 9:53 pm

Am having both decimal and whole numbers in my list. If the input is decimal then i need to change into a whole number or else i shud retain the input.
For example if the input is 0.1 then the o/p shud be 10 and if the input is 5 then o/p shud be the same 5.

Thanks in advance

Minhajuddin · Post by **Minhajuddin** » Tue May 06, 2008 10:44 pm

With what logic are you converting 0.1 to 10, are you multiplying with 100?
What do you expect when the input is 0.01?

ray.wurlod · Post by **ray.wurlod** » Tue May 06, 2008 11:41 pm

Moderator: please move to server forum

veera24 · Post by **veera24** » Thu May 08, 2008 9:42 pm

Minhajuddin wrote:With what logic are you converting 0.1 to 10, are you multiplying with 100?
What do you expect when the input is 0.01?

Actually the column consists of both kinda data i mean decimal as well as whole number.
Am in need to convert the decimal value by multiplying with 100. Because we are treating the decimal data as a percentage value.

Thanks..

ShaneMuir · Post by **ShaneMuir** » Thu May 08, 2008 10:09 pm

Two options:

1. Check if the first char is 0, if yes then multiply by 100 else pass the input value. eg If left(input.col,1)=0 then input.col*100 else input.col
2. Check if the input value has a decimal (.) in it, if so multiple by 100 or pass the input value eg If index(input.col,'.')<>0 then input.col*100 else input.col