0

Rounding Values

Jet Reports Historic Posts

March 13, 2017 14:33

None

Follow

Greetings,

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

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts March 13, 2017 14:33

  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

• 0
  
  Jet Reports Historic Posts March 13, 2017 14:50

  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?

• 0
  
  Jet Reports Historic Posts March 13, 2017 14:57

  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