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 ?

    PAUL YEO

      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