This discussion is archived
1 Reply Latest reply: Oct 15, 2013 5:55 PM by thanasis_agr RSS

Need to trim decimal Places in data pulled in Financial report

Sattu28 Newbie
Currently Being Moderated


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.

 

Thanks,

 

Satish

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points