Hi all,

I am working in CR to create an overview for a bank. I want to export the file into a text file.
In the footer I want a count and a sum of all the different payments. These fields needs to be 6 and 10 characters long. I used to next formula's:

Count:
Right('000000' & count({RELACIONADO.IDI}),6)

Sum:
Right('0000000000' & sum({DEUDA.CAPITAL}),10)

But when I do this, for the count, I got for example 100.00 where I would like him to give me 000100.

What do I need to change in my formula to get the results in the right way? Can anybody help me?

Thank you all in advance

Kind regards,

Gerben

Almost there. It is now giving me 14,026, where I would like him to show it like 014026. Is it something in the formula, of do I need to change some settings somewhere?

Works perfect now, thank you very much!