Amount in Words

[Jeetj]

I have a field on the report which is numeric. I am also displaying a formula field which calculates the sum of this field.

for eg, if i have amounts like 100,1000,10000,1000000 etc,
the formula field calculates the total of these amounts.

Now i want to convert this into words. I use the To Words function. For amounts greater than 10 lakhs it prints as Ten million. eg. if the total is 1234567. it shows a Twelve million Thirty Four thousand five hundred sixty seven.

i want this words to be shown in UK format. i.e Twelve lakhsthirty four thousand five hundred sixty seven.

hoping to get a solution to this.

thanks in advance.

Jeet

 

[Ngolem]

"if the total is 1234567. it shows a Twelve million Thirty Four thousand five hundred sixty seven.

i want this words to be shown in UK format. i.e Twelve lakhsthirty four thousand five hundred sixty seven."

I think you are out a a bit here...

Do you mean 1234567 is 0ne million 2 hundred thirty Four thousand five hundred sixty seven...and you want it to read

one lakhs two hundred thirty four thousand five hundred sixty seven.

so 1 lakhs = 1 million (of whatever the units for this are)

BUT do you want the conversion to lakhs to take place only if there are more than 10 lakhs??? is that what you want???

anyway here is a formula that might do the trick

if truncate((summed value)/1000000) > 0 then
ToWords(truncate((summed value)/1000000)) + " lakhs " +
ToWords(remainder((summed value),1000000))
else
ToWords(remainder((summed value),1000000)) ;

I think that will work for you

JimBroadbent@Hotmail.com