Crystal Report: Convert Amount to Words

Spread the love

Report Application: Crystal Report

Version: 2013


I have a field {ARIBH.AMTNETTOT} that has amount in figures and the client needs the amounts in words


//extract Naira  only

Propercase(ToWords(truncate({ARIBH.AMTNETTOT}),0) + ‘ Naira and ‘ +

//extract the Kobo and convert to words Another formula for rounding up.
ToWords(remainder({ARIBH.AMTNETTOT}*100,100),0) + ‘ Kobo Only.’)


Do have a lovely day