Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a QV doc which is having this problem for quite some time , i already posted few time , still not able get any reply. Hope this time i am lucky.
Let me share with you how i make currency format display ? For example user select SOURCE = TDSPG , which is malaysia company , the currency sign RM$
My problem is not all the company display RM $ sign.
Step i create dynamic currency sign display.
1. Create in line load for user to select to display in Org or S$ currency ( Org = Orginal country currency )
LOAD * INLINE [
What If Dimension Rate, Column89
S$,Rate
Org,Rate_
];
2. I also give the currency conversion rate , this will allow QV auto convert the currency amount .
LOAD * INLINE [
SOURCE,Currency, Rate
TDSS,SGD, 1
ADL,SGD, 1
TDSPG,RM, 2.4
3. i also create a inline load for CurrencyFormatK, this var will call by system var.
Currencies1:
LOAD * INLINE [
SOURCE: CurrencyFormatK:
TDSS: SG $#,##0 K;(SG $#,##0 K)
ADL: SG $#,##0 K;(SG $#,##0 K)
TDSKL: RM $#,##0 K;(RM $#,##0 K)
4. My expression in table using vMoneyFormatK as below :-
money(
sum({$<year = {$(=max(year)-0)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}sales/$(Columndim89)/1000)
, $(vMoneyFormatK))
So I need to create system var for vMoneyFormatK , the expression as :-
=IF([What If Dimension Rate] = 'Org' OR getselectedcount([What If Dimension Rate]) <> 1, 'CurrencyFormatK', vWhatIfMoneyFormatK)
5. Since step 4 system var expression call vWhatIfMoneyFormatK , therefore i need create vWhatIfMoneyFormatK the expression as :-
=chr(39) & [What If Dimension Rate] & ' #,##0 K;(' & [What If Dimension Rate] & ' #,##0 K)' & chr(39)
Hi All
Can some one confirm for me , it is this is bug from QV ? As i posted this similar question fews time unable to get any reply.
Paul
Without looking in your app I believe per variable-defined dynamically formatting is generally problematic. I had had probably a similar issue which was caused through null-values within the calculation. This meant was one single calculated record within the expression null, my result was a string else it was a numeric value. I suggest you should select your data and search on a lower level to find abnormality.
- Marcus
Hi Marcus
You are quite right , because this happen only when Diamension = company.
i do have Diamension = SBU , which is very well structure data , it does not missing value , and it can display currency sign without any issue.
Thank you for your sharing.
Paul