Sage Simply Accounting Intelligence
Sage Simply Accounting is the #1 choice of Canadian small businesses and accountants and used by more than 500,000 Canadian Businesses.See More
Leon Colton's Groups
-
Sage Simply Accounting I…
88 members
-
Report Designer
99 members
-
Sage ERP Accpac Intellig…
135 members
-
Excel on Steroids
150 members
Leon Colton's Discussions
Totals of Pivot Table
2 Replies
Is there a way to calculate Total amount of a column in Pivot Table differently than the formula used in this column?Let's say you want to see Total of Column A as a % of Total of Column B out of…Continue
Started this discussion. Last reply by Leon Colton May 27, 2011.
VARIANCE PERCENTAGE
3 Replies
To calculate monthly Variance between Actual and Budget in $ in Income Statement is easy, but the % of Variance to Budget is totally different 'ball game'. The problem stems from Budget and Actual…Continue
Started this discussion. Last reply by Leon Colton May 20, 2011.
Clearing Filter Values from Pivot Table
4 Replies
Did anybody come across that phenomenon when you run report the second time with different data and the values from the first run still remain in the filter, although the associated rows are not…Continue
Started this discussion. Last reply by Leon Colton Apr 30, 2011.
DEPARTMENTAL DISTRIBUTION OF THE REPORT
2 Replies
Suppose you have a Pivot Table Report for Departmental Cost Analysis, and you want to distribute the cost report monthly to each Departmental Head. Now the Department is in the Report Filter, and…Continue
Started this discussion. Last reply by Leon Colton Apr 13, 2011.
Leon Colton's Page
Latest Activity
Leon Colton replied to Maree Palmer's discussion Accpac AR Invoices and Customer Optional Fields"The additional complexity of this report comes from the fact there are two Optional Fields, therefore it shows two instances for each detail line. Are you building your report as a Pivot Table? If so, there are a few ways to go about it. I’m…"
Leon Colton replied to Rickert Melim's discussion Sales Master in Evolution"It can be done if you have a SAI Connector license, as the Sales Master report doesn't hold that field. You might need also to copy the canned Sales Master report first, before doing any changes.
Add the Balance Due field to the list of…"
Leon Colton replied to Reinhard Erb's discussion Connector License not ON"Did you try to run Accpac as Administrator after installing and activating the SAI Connector module?"
Leon Colton replied to Leon Colton's discussion Totals of Pivot Table"That's what I was hoping for...unfortunately you can't summarize this field by Average, as there are zero value cells, that will distort the Total, and if you change the value field settings only for totals, it will apply these for…"
Edwin replied to Leon Colton's discussion Totals of Pivot Table"Hi,
A combination of calculated fields and value field settings can help.
"
Leon Colton posted a discussionTotals of Pivot Table
Is there a way to calculate Total amount of a column in Pivot Table differently than the formula used in this column?Let's say you want to see Total of Column A as a % of Total of Column B out of Total of Column C, in Pivot Table line of Grandtotals.See More
Leon Colton replied to Leon Colton's discussion VARIANCE PERCENTAGE"All right, got it sorted my adding a macro to the report. The Excel formula will calculate a total of both lines, budget and actual, and divide it to budget."
Leon Colton replied to Leon Colton's discussion VARIANCE PERCENTAGE"Well, that woldn't work unfortunately - I need them in two separate lines, for other calculations. I need somehow relate to the previous or next line and if budget is set for this account to divide Monthly Varience on Monthly Budget.
Any…"
Shwu Hua Gan replied to Leon Colton's discussion VARIANCE PERCENTAGE"Hi,
With standard connector from Sage Intelligence, if I remember correctly, the name is called Financial Reports or Financial Analysis.
With that connector, there are fields for Actual and Budget for each period which calculated based…"
Leon Colton posted a discussionVARIANCE PERCENTAGE
To calculate monthly Variance between Actual and Budget in $ in Income Statement is easy, but the % of Variance to Budget is totally different 'ball game'. The problem stems from Budget and Actual figures come in two separate rows in raw data sheet, so when presenting them in Pivot table it gets summed up automatically for all rows of the Account. But when it comes to % calculation, how it can be calculated, if Actual is on one row and Budget is on another? Formula for next record perhaps?All…See More
Leon Colton replied to Leon Colton's discussion Clearing Filter Values from Pivot Table"That worked! Although it requires additional acrobatics beside this periodic maintenance clean up, such as linking Template again, it does the trick... I guess it gives some improvement ideas for the next SAI version, doesn't…"
Stephen Coull replied to Leon Colton's discussion Clearing Filter Values from Pivot Table"Hi Leon,
From within the Report Manager, you can right click on your chosen report and choose the "Clean Template Pivot Fields" option which will allow you to clean out all your chosen fields.
Hope this helps!"
Profile Information
- Alchemex Powers the Following BI Solution, Pick Yours
- Sage Accpac Intelligence
- Website
- http://www.plus.ca
- About Me:
- Accpac Consultant, currently testing the SAI product
- How long have you been using the above solution?
- 2 months
- Where did you hear about us?
- Other
- If other, please specify
- Sage Software
Leon Colton's Photos
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
