why currency sign can display on table 1 but not display on Table 2 USING SAME EXPRESSION ?

[paulyeo11]

Hi All

I have below expression from table 1 it can display currency sign :-

Money(RangeSum(Above(TOTAL Sum(DISTINCT{<year = {"$(=Max(year)-0)"},$(ColumnDim51) ={$(ColumnDim51)}>} Amount*1/ $(Columndim89)/1000), 0, RowNo(TOTAL))), $(vMoneyFormatK))

When i apply the above expression to Table 2 , the currency sign does not appear.

I have check on Table 2 expression  :-

1.Make sure the expression at number tab set to expression default.

2. I don't know why table 1 expression with Dimension 601 select not work ?

Paul

[Chanty4u]

is the column names are availble in  table2 also? 

[paulyeo11]

Hi Chanty

I though currency sign is control by below code :-

$(vMoneyFormatK))

Not sure what you mean ?

Paul

[Chanty4u]

SET MoneyFormat='$#,##0.00;-$#,##0.00';

[Chanty4u]

or else

in chart properties,on number tab, right down, you can define the symbol for pound, dollar..etc....

[paulyeo11]

Hi chanty

Mine currency is dynamic depend my source data from each country.

Paul

Sent from my iPhone

[paulyeo11]

In my expression I already set the currency sign , I use same expression but it display on one table but not table 2

Sent from my iPhone

[Chanty4u]

did u try with the sample  data  with same exp?

or else u can restrt ur Qvw