Currency Symbol display

[#1]

=If( GetSelectedCount( LuCurrencyType3 )>0,

num(sum(IF([Month of Expense]=MONTH(Today()),

   IF([Year of Expense]=YEAR(Today()),[Expense Amount (USD)]/Factors,varCurrencySymbol& ' '& '#,#00.0' ))))

, num(sum(IF([Month of Expense]=MONTH(Today()),

     IF([Year of Expense]=YEAR(Today()),[Expense Amount (USD)],varCurrencySymbol& ' '& '#,#00.0')))))

I have the above expression I am not able to get the currencysymbol working.Also,in Number I have set to expression default,but still it is not defaulting to single decimal.

varCurrencySymbol has list of different currency symbols (in text format)

Thank you.

[sunny_talwar]

Can you try this:

=If(GetSelectedCount(LuCurrencyType3) > 0, Num(Sum(If([Month of Expense] = Month(Today()),

  If([Year of Expense] = Year(Today()), [Expense Amount (USD)]/Factors, '$(varCurrencySymbol)#,#00.0')))),

  Num(Sum(If([Month of Expense] = Month(Today()),

  If([Year of Expense] = YEAR(Today()), [Expense Amount (USD)], '$(varCurrencySymbol)#,#00.0')))))

[#3]

Thank you but it is displaying values as 3876964.4687334

[sunny_talwar]

What do you see when you put $(varCurrencySymbol) in a text box object?

[#5]

I have set varCurrencySymbol to maxstring(CurrencySymbol)

I see the above image

[sunny_talwar · Accepted solution]

Check out the attached qvw

[#7]

Awesome.Thank you very much.Really appreciate your help ,patience and willingness to help.Stay blessed

[sunny_talwar]

Not a problem. Just curious to know what were you doing differently that was not working in your application initially?

[#9]

The close parenthesis for Num(sum( was not placed appropriately.