This is a migrated thread and some comments may be shown as answers.

Digit grouping not working

0 Answers 41 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Muhammad
Top achievements
Rank 1
Muhammad asked on 15 May 2018, 11:06 AM

Hi, 

I am working on a report that include some columns of currency. I have stored the currency symbols in database and fetching the appropriate form there. 
I am not able to group numbers when I concatenate currency fields with number field.

=Fields.(DrAmount)
When I apply grouping on above field I get appropriate result i.e 15,000.

=Fields.CurrencySymbol+' '+(Fields.DrAmount)
When try this one I can't group numbers and I get the result like this. i.e Rs 15000.0000

=Fields.CurrencySymbol+' '+CDbl(Fields.DrAmount)
When try this one I get the result like this. i.e Rs 15000

 

No answers yet. Maybe you can help?

Tags
General Discussions
Asked by
Muhammad
Top achievements
Rank 1
Share this question
or