Showing a Non-numeric field as Numeric

  1. Click on the grid to get the binding gear to show and click on it.
  2. Select the Id and then click the function icon

3.  Give the function a name – in this case ID as Num

4.  In the Function box type ToInt(Id) – This is stating that you want the ID field to be an integer.

5.  Close the function box and select the Format section.

6.  In the format section set the Format Type to Number, the Unit to One, and the Precision to 0


**For further assistance with Dashboards use the links at Dashboards