Lantica User Forum - Controlling decimal places in Summary Calculations

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Controlling decimal places in Summary Calculations

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Pages: 1

Controlling decimal places in Summary Calculations (Read 832 times)

Robert Member Offline Posts: 35 Joined: May 7^th, 2013	Controlling decimal places in Summary Calculations Oct 13^th, 2014 at 4:42pm	Print Post
	I know how to set the decimal places on a value box field on a report. But when it's a summary calculation like AVG you don't get the same options. How would you specify to just round the value or even just bring it down to 1 decimal place. Here's an example: AVG #DAYS_ARREST TO_BOARD ACTION AVG #DAYS_BRD ACTION TO_TRANSPORT DATE AVG #DAYS_ARREST TO_TRANSPORT DATE 31.600000 197163.820000 197195.420000


	IP Logged

Robert Member Offline Posts: 35 Joined: May 7^th, 2013	Re: Controlling decimal places in Summary Calculations Reply #1 - Oct 13^th, 2014 at 4:51pm	Print Post
	I realized the calculated fields are in the program layout and tried this: CALC1410360534 = @Decimals(CALC1410360534,2) But it didn't change anything.


	IP Logged

Robert Member Offline Posts: 35 Joined: May 7^th, 2013	Re: Controlling decimal places in Summary Calculations Reply #2 - Oct 13^th, 2014 at 4:53pm	Print Post
	@ROUND didn't change it either.


	IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Controlling decimal places in Summary Calculations Reply #3 - Oct 13^th, 2014 at 9:06pm	Print Post
	Hello Robert, With the calculation element selected, on the Format tab of the Property Editor, under Display Format choose Custom Format. Then you can set the display options that you would like to use. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Robert Member Offline Posts: 35 Joined: May 7^th, 2013	Re: Controlling decimal places in Summary Calculations Reply #4 - Oct 13^th, 2014 at 9:53pm	Print Post
	When I do that my options are "As Entered, UPPERCASE, lowercase, Initial Caps". This was an element added from the Summary Calculation functions.


	IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Controlling decimal places in Summary Calculations Reply #5 - Oct 14^th, 2014 at 2:29pm	Print Post
	Hello Robert, The value boxes that you are averaging in your report, are they set to be formatted as number? It is sounding like the value boxes you are averaging are set as Text so the summary calculation element is displaying the format options for Text. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Pages: 1

‹ Previous Topic | Next Topic ›