Some company sales amount not able display currency sign ?

[#1]

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)

[#2]

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

[marcus_sommer]

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

[#4]

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