Skip to main content
Topics#Data ManagementDomanda di Gautham Saudagar
Gautham Saudagar (Slalom LLC) ha fatto una domanda in #Data Management
1 nov 2018, 15:56

Displaying currency in table

Hi Guys!, I'm trying to display currency symbol for each items I'm iterating in a table in my component. I found that !$Locale.currencyFormat is the format to return user's currency but I'm not sure how to figure out a way to use this in my table so that I can display Currecy Symbol for a particular field for each record.

 

Any Idea How I can implement this? Thanks!
10 risposte
  1. Gautham Saudagar (Slalom LLC)
    1 nov 2018, 20:02

    Appreciate the help Bro! But I think I found a way to do this. Rather than adding it on UI, I've modified my query to return the number along with its currency and It worked as magic. 

    SELECT CALENDAR_YEAR(Cashflow_Date__c) Year, FORMAT( SUM(Contribution__c) ) Contribution, FORMAT( SUM(Withdrawal__c) ) Withdrawal  
                    FROM [Object]
                    WHERE [Object] = :'Id'
                    GROUP BY CALENDAR_YEAR(Cashflow_Date__c)

     

    But one small issue is, that for the Calender Year which have no contribution the value getting displayed is  

     

    I Dont know why :(

     

    Appreciate the help Bro! But I think I found a way to do this. Rather than adding it on UI, I've modified my query to return the number along with its currency and It worked as magic.

     

    Any Idea how I can remove this &nbsp from UI.
Scrivi una risposta...
0/9000