Change the format of a text object

[#1]

Hi you all,

I've got a text object and that shows an outcome. My formula gives me an outcome like 1560000.

=

'Total ' &num#(round(sum( {1<type= {dagb.intra}>} Dagdelen) - sum ({1<type= {dagb.intra}>} Totaal) * para))

I would like to set the numbers in the outcome to 1.560. 000

[#2]

Try this

='Total ' & num(num#(round(sum( {1<type= {dagb.intra}>} Dagdelen) - sum ({1<type= {dagb.intra}>} Totaal) * para)),'###,##0.')

Rich

[#3 · Accepted solution]

Thx for the direction. Your syntax does not do what I want but I've changed it to:

='Total ' & num(num#(round(sum( {1<type= {uren}>} (UrenExtramuraal)/60) - sum ({1<type= {uren}>} Totaal) * para)),'.###.###')

Now it gives the right outcome: 1.560.000