Thousands Separator in Reports

If you think that something doesn't work in Aware IM post your message here
Post Reply
ColinP
Posts: 30
Joined: Thu Jul 09, 2020 7:57 am
Location: London UK

Thousands Separator in Reports

Post by ColinP »

<<Object.Number,#,##0.00>> gives 'Syntax Error at Token ',' (Column x)

works fine without the thousands separator.

tried /, and \, and '#,##0.00' and even #+##0.00 - that was interesting it produced 1234.56+
Colin
------------------------------------------------------------------------------------------------------------------------
AwareIM 8.7 (Build3012) Windows Virtual Server Derby
customaware
Posts: 2391
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Thousands Separator in Reports

Post by customaware »

Have you tried <<Object.Number,'#,##0.00'>> ?
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
ColinP
Posts: 30
Joined: Thu Jul 09, 2020 7:57 am
Location: London UK

Re: Thousands Separator in Reports

Post by ColinP »

sure have
<<Costings.Style.SPQuantity*Costings.Style.SPinGBP,'#,##0.00'>>

see error attached

is it because it is a calculation???

Yes! it is.
<<Costings.Style.SPQuantity,'#,##0.00'>> works fine, but even enclosing the calculation in () doesn't resolve the error.

Woe is me! Do I really have to put this figure in the database????
Attachments
Capture.JPG
Capture.JPG (13.45 KiB) Viewed 4951 times
Colin
------------------------------------------------------------------------------------------------------------------------
AwareIM 8.7 (Build3012) Windows Virtual Server Derby
customaware
Posts: 2391
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Thousands Separator in Reports

Post by customaware »

Whoops!.... Try this....

<<Costings.Style.SPQuantity*Costings.Style.SPinGBP@'#,##0.00'>>
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
ColinP
Posts: 30
Joined: Thu Jul 09, 2020 7:57 am
Location: London UK

Re: Thousands Separator in Reports

Post by ColinP »

Dear Eagles9999,

Brilliant! Works a treat - I can't thank you enough.

How did you discover this. It makes me feel pretty stupid.

best wishes
Colin
------------------------------------------------------------------------------------------------------------------------
AwareIM 8.7 (Build3012) Windows Virtual Server Derby
Post Reply