1 Reply Latest reply on Oct 16, 2013 12:55 AM by Thanos A.

    Need to trim decimal Places in data pulled in Financial report


      Hi All,


      We have a Financial report in which in partcular column, data is being pulled by the formula :

      <<CellText("Grid1", Cur, C(A), 1)>>

      Some cells in that column contains only text comments, some cells having numbers only.

      Issue is with the numbers. Numbers when pulled in FR are being dispalyed upto 6 decimal places, i.e. 1234 is displayed as 1234.000000.

      So if somebody can suggest how can we modify the formula so that we can display the numbers without decimal values. i means , numbers being pulled are displayed as 1234 only not like 1234.000000.