Digit grouping not working

1 posts, 0 answers
  1. Muhammad
    Muhammad avatar
    27 posts
    Member since:
    Oct 2017

    Posted 15 May 2018 Link to this post

    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

     

Back to Top