Calculating Sums of columns

Postby wms7328 » Sun Jul 31, 2016 1:46 pm

I have a report that gives the expenses for current month, YTD totals and Annual Budget sorted by sub account number. At the end of each subaccount it calculates the total for each of these columns. However, for the YTD totals it doesn't print out the cents, example $200.77 will print as $200.00. It keeps the cents for the current month totals OK. Can't see where there are any difference in report layout for the two columns.

Thanks for any help.
wms7328
 
Posts: 233
Joined: Tue Apr 26, 2005 7:45 am
Location: Unity Presbyterian Church

Re: Calculating Sums of columns

Postby wms7328 » Sun Jul 31, 2016 2:10 pm

I just changed one of my budgets to include cents, we normally just budget in whole dollars. The custom report referenced in previous post also does not print out the cents for the annual budget column. So, the only column that calculates the totals to include cents is the first one listed, the other columns only print out in whole dollars.

Any ideas??
wms7328
 
Posts: 233
Joined: Tue Apr 26, 2005 7:45 am
Location: Unity Presbyterian Church

Re: Calculating Sums of columns

Postby NeilZ » Sun Jul 31, 2016 5:16 pm

wms7328 wrote:I just changed one of my budgets to include cents, we normally just budget in whole dollars. The custom report referenced in previous post also does not print out the cents for the annual budget column. So, the only column that calculates the totals to include cents is the first one listed, the other columns only print out in whole dollars.

Any ideas??


Did you create variables to sum the columns, or are you using built-in variables?

Neil Zampella

Using PC+ since 1999.
NeilZ
 
Posts: 8906
Joined: Wed Oct 08, 2003 12:20 am
Location: Connellsville, PA

Re: Calculating Sums of columns

Postby wms7328 » Sun Jul 31, 2016 6:42 pm

I'm using the built in variables that says sum. It's doing the first column correctly but then for the next two columns it drops the cents.
wms7328
 
Posts: 233
Joined: Tue Apr 26, 2005 7:45 am
Location: Unity Presbyterian Church

Re: Calculating Sums of columns

Postby Zorak » Mon Aug 01, 2016 8:29 am

Double click on the output field in the report designer. Click on the Format tab and choose numeric. Then enter 9,999,999.99 (or however big of a number you are expecting) in the Format Expression field. Don't add the commas if you don't want the thousand separator.
Zorak
Tech Support
Tech Support
 
Posts: 2493
Joined: Thu May 13, 2004 8:59 am
Location: PowerChurch Software

Re: Calculating Sums of columns

Postby wms7328 » Mon Aug 01, 2016 9:02 am

Thanks that solved the issue. I knew it was something simple just couldn't figure out what.
wms7328
 
Posts: 233
Joined: Tue Apr 26, 2005 7:45 am
Location: Unity Presbyterian Church