6 Replies Latest reply: Aug 19, 2009 3:38 AM by kyaw zorr RSS

    Help for about decimal.

      Hello,

      In Pivot table , Expression i used the num( ) function. The function is show the decimal place is correct but when the formula was manipulated they used the original value. That mean

      i used the function like that,

      num('0.32409178531','.##') * num('40648.216','.##') => 13173.752893

      I checked each function's output is correct , num('0.32409178531','.##') output is => 0.32

      num('40648.216','.##') output is => 40648.22

      but combine these functions together

      num('0.32409178531','.##') * num('40648.216','.##') output=> 13173.752893

      The answer should be, 13007.

      Can anybody help me? Thanks a lot for advance.