Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=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.
Check out the attached qvw
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')))))
Thank you but it is displaying values as 3876964.4687334
What do you see when you put $(varCurrencySymbol) in a text box object?
I have set varCurrencySymbol to maxstring(CurrencySymbol)
I see the above image
Check out the attached qvw
Awesome.Thank you very much.Really appreciate your help ,patience and willingness to help.Stay blessed
Not a problem. Just curious to know what were you doing differently that was not working in your application initially?
The close parenthesis for Num(sum( was not placed appropriately.