7 Replies Latest reply: Mar 13, 2016 11:37 AM by Chanty 4u

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

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

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

is the column names are availble in  table2 also?

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

Hi Chanty

I though currency sign is control by below code :-

\$(vMoneyFormatK))

Not sure what you mean ?

Paul

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

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

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

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

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

did u try with the sample  data  with same exp?

or else u can restrt ur Qvw

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

or else

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

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

Hi chanty

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

Paul

Sent from my iPhone