• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 705
  • Last Modified:

Format number in formula

Hi,

I search to format a number in a formula.
In my report, the format of the number is ###,##0.00 for example and i want that a number in a formula be ###0 without .00
Somebody know how to do that ?
0
clefev01
Asked:
clefev01
1 Solution
 
DRRYAN3Commented:
Right click on the field, choose format field, click on the number tab at top of dialog, click on -1123 in the list.  Click on OK.

DRRYAN3
0
 
mlmccCommented:
Open the report
Select the field
Click Format --> FORMAT FIELD
Select CUSTOMIZE
Set DECIMALS to 1
Set Rounding to 1
Select OK
Select OK

It should now print as 1234 rather than 1234.00

mlmcc
0
 
FluffyBunnyCommented:
YOu can format a number in a formula with the following syntax:

tonumber(fieldname,decimals,seperator)

in your case, the formula would look like this:
tonumber(fieldname,0,'')

Regards,
FluffyBunny
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now