Rounding Values

Discussion & Feedback for Jet Enterprise
Posts: 19
Joined: Tue May 26, 2015 8:13 am

Rounding Values

Postby Colleyv12 » Mon Mar 13, 2017 7:33 am

I need to apply a normal ROUND(Field,2) to a sales invoice line custom field

I can only see the normal Field transformations available, not ROUND,

Do I have to create a new field and apply the custom transformation, or can it be applied to the original value somehow?


User avatar
Jet Reports Certified Professional
Posts: 442
Joined: Wed May 26, 2010 3:40 pm

Re: Rounding Values

Postby HPDeskJet » Mon Mar 13, 2017 7:50 am

What is the issue you are experiencing? (i.e., what do you mean when you state you can "only see the normal field transformations..."?)

What type of Jet function are you using?

What is the field type of the customer field?
Jet 2015 Certified Trainer

Posts: 19
Joined: Tue May 26, 2015 8:13 am

Re: Rounding Values

Postby Colleyv12 » Mon Mar 13, 2017 7:57 am

Normal Transformations e.g.Default, First, Fixed, Last , Lower, ReverseSign etc that can normally be applied to the source field

The source field is a decimal, records can be 1.2345, 3.5678

I want to bring them through as 1.23, 3.57 so any calculations are using the rounded values

The Jet function will be


I cannot apply an excel formula as it will be applied to the total, not individual records


Posts: 8
Joined: Mon Mar 09, 2015 10:58 am

Re: Rounding Values

Postby RyanP » Mon Mar 13, 2017 10:18 am


To accomplish this, you will need to setup a 'Custom' transformation on the field and apply the SQL ROUND function within the code.
round.png (6.48 KiB) Viewed 180 times

Return to “How do I?”

Who is online

Users browsing this forum: No registered users and 2 guests