Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I'm making a dashboard linked to a NAV database.
Within this NAV database there is setting ocal currency with the corresponding symbol. I have putted this currency symbol in a variable.
Now I want this variable added to the moneyformat in the script.
something like
SET MoneyFormat ='$(vCurrSymbol) & #, ## 0.00; -$(vCurrSymbol) & #, ## 0.00";
Only I do not get the right result. The variable is displayed as text.
Can anyone help me?
Thank you very much
Sorry for my misunderstanding, I'm not working with QV for that long but I don't see how I can do that
When you load SaleslineAmount, you can use instead:
dual(CurrencyCodesSymbol & ' ' & num(SaleslineAmount, '#,##0.00', '.' , ','), SaleslineAmount) as SaleslineAmount,
but field CurrencyCodesSymbol should be in the same source table.
Thank you very much for your help
This trick with text representation works not only with tables but also with charts (values on data point and so on).