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

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

    Yeo Poh sai

      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 ?