Rounding Values

Discussion & Feedback for Jet Enterprise
Colleyv12
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?

Regards

User avatar
HPDeskJet
Jet Reports Certified Professional
Posts: 441
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?
-HP
_______________________
Jet 2015 Certified Trainer

Colleyv12
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

=NL(CubeValue,Cube,Field)

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

Thanks

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

Re: Rounding Values

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

Greetings,

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


Return to “How do I?”

Who is online

Users browsing this forum: No registered users and 1 guest