Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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.
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
Hi,
Please share a sample Qvw for better suggestion.
Thanks
Raja
You welcome Marie Billaud