Format value in a text object

[amber2000]

Hi,

I would like to format a value in a text object:

The value looks like this: 1948738 and I want it to be 1.948.738

This is what I set in the General Tab in Text:

='Amount of Cases - ' & sum(PL_Nr_Of_Cases)

Does anyone has an idea on how I can do that please?

Kind regards,

Monique

[antoniotiman]

Hi Monique

='Amount of Cases - ' & Num(sum(PL_Nr_Of_Cases),'#.##0')

Regards,

Antonio

[#3]

Hi,

try this:

='Amount of Cases - ' & num(sum(PL_Nr_Of_Cases),'#,##0')

Thanks!

[miguelbraga · Accepted solution]

Hey there,

Try this expression:

='Amount of Cases - ' & Num(1948738 ,'#.##0', ',', '.')

Best regards,

D.A. MB

[amber2000]

This works perfectly, thanks guys