Hello All,

Please i need amount in word formula, the one am using is not coming out very well. Please find screen shot below.

This is the formula that i 'm using below. 

Propercase(ToWords(truncate(Sum ({PORDERQ.LINAMT_0})),0) + ' Naira and ' + 
ToWords(remainder(Sum ({PORDERQ.LINAMT_0})*100,100),0) + ' Kobo Only.')

Thanks .

Samuel