Alchemex Certified Professional Consultants
Information
Alchemex Certified Professional Consultants
Discussion Forum
Error in Assignment 4 Replies
Peachtree 2012 database >> Alchemex v7. I created a union report with 2 child reports. Everything works fine on my machine, but when delivered to client machine, I get an error > Error in…Continue
Started by Dave Smith. Last reply by Dave Smith Mar 7.
VLOOKUP in a container 2 Replies
Using v7 to create a commission report from Peachtree data. I need to deduct an early pay discount from the invoice total before commission is calculated. Sales Data is in the Sales Journal and EP…Continue
Started by Dave Smith. Last reply by Dave Smith Feb 15.
Alchemex Smart Reporting Partner Getting Going document
Take a look at the new Alchemex Smart Reporting Getting Going document giving you the relevant links as an Alchemex Consultant to getting going with Alchemex Smart Reporting in 5 easy steps.…Continue
Started by Bron Dorrofield Sep 20, 2011.
Alchemex Demonstration
Hi Guys, Please be aware that I will be hosting a demonstration on Alchemex on Tuesday the 1st of February at 4pm (GMT+2). Please feel free to invite any of your prospects or clients to…Continue
Tags: demo
Started by Geoffrey Hickley Jan 27, 2011.
Comment Wall
Comment
-
Comment by Dave Smith on October 15, 2011 at 8:50pm -
AVOID THE WORD “BLANK” ON A PIVOT TABLE
In a new column of the Raw Data Sheet, place this formula =IF(ISBLANK(E2),"unpaid",E2) on row 2. E2 is the 1st cell address of the original data column that has blanks and “unpaid” is the text you want instead of blank. Then name the New Column. Place an Add-In on the Properties tab as in the 1st pic below. After hitting OK, the 2nd pic comes up.
Go ahead and select the Fill in Example button. Change the settings as follows: The column to begin at is the position of the new column, counting from the left. If the formula is in row 2, put 3 in the next field “copy to.” Excel Range to Copy is the cell address of the formula. In the next field, column 1 is ok. No for replace formula with value. End column number = 1. Insert new rows = no. Then on the pivot table, put the new column in place of the old one that was producing “Blank.”
-
Comment by Bron Dorrofield on April 5, 2011 at 7:45am
-
URGENTLY required, proficient BIC Consultant for short term contract or freelance work – inbox info@orpsys.com #Pastel Partner #BIC #JHB
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
You need to be a member of Alchemex Certified Professional Consultants to add comments!