Text Object with variables - Formatting

[Anonymous]

Hi everyone !

I would like to create a text object box using variables.

My issue is with the result's format.

I have 2 variables vFirst Text and vSalesThisMonth.

vFirstText

='Sales This Month'

vSalesThisMonth

=sum({$<Year = {$(=max(Year))}, Month_num = {$(=max(Month_num))}>}[Amount Sales Local]/(if(%Currency='Local',1,[EUR Rate]/100)))

Text Object:

=vFirstText&':'&vSalesThisMonth

Returns

Sales This Month : 1234567,1234567

I would like to format the total and get ''Sales This Month : 1 234 567''

Any ideas to fix this ?

Thanks & Best regards !

[Anonymous]

Hi,

you can try add the num format  in your variable.

=Num(sum({$<Year = {$(=max(Year))}, Month_num = {$(=max(Month_num))}>}[Amount Sales Local]/(if(%Currency='Local',1,[EUR Rate]/100))),'#,##0')

Regards.

[Anonymous]

Hi Jannet,

Thank you for you reply

I changed it but it's not changing anything at all...

Then I tried: Num(vSalesLastMonth,'#,###,###,###')

And my result is 1234567,438,###,###

Do you know what I am doing wrong ?

Thanks for your help

[arasaraja_cts]

Hi,

Please share a sample Qvw for better suggestion.

Thanks

Raja

[Anonymous]

You welcome Marie Billaud