Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

REPORT DESIGN : Adding 3 Columns of numeric data

Sage 50 general help forum - Free help and support for all general issues
Post Reply
saba
User
User
Posts: 1
Joined: 24 Mar 2011, 17:53
Sage Version: v2009 15 UK/Europe/Africa

REPORT DESIGN : Adding 3 Columns of numeric data

Post by saba » 24 Mar 2011, 18:00

Hi there,

I would love some help. I have designed a report where i have 3 columns of data

Column 1 : Quantity (In Units)
Column 2 : Price 1 (£)
Column 2 : Price 2 (£)

How do i create an expression to add up each separate column?
I would then place this expression at the bottom of each column.

Thanks so much :)

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: REPORT DESIGN : Adding 3 Columns of numeric data

Post by brucedenney » 07 Apr 2011, 10:15

Depends on the version of Sage you are using.

Assuming a recent one, you add the item to the footer section and set the "function" property to "sum"
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: Amazon [Bot], Google [Bot] and 2 guests