Question about Business & Productivity Software
The Calculated field if used to calculated the difference between 2 fields gives the difference in amount. Is there a way to get the difference in count. The count formula in Calculated field doesn't seem to work. Kindly help
Count will only work with numbers. So select another box where you want your number and use this formula: =count(x:x) This should give the count number then you will need to find the difference. In another box, use =sum(x-x). This should give you your difference.
If this helps you, please rate me. Thanks, Patty
Posted on Dec 30, 2007
Tips for a great answer:
Sep 30, 2011 | Microsoft Excel for PC
Sep 30, 2011 | Microsoft Excel 2010
Jul 22, 2009 | Microsoft Office Excel 2007
May 07, 2009 | Microsoft Excel for PC
Mar 01, 2008 | Business & Productivity Software
Feb 23, 2008 | Microsoft Office Standard for PC
Jan 03, 2008 | Business & Productivity Software
Prepare table having coloumns Client, Premium Amount , Month.
Now take Pivot table of the above table. Take Field 'Month' in Page field and Client in 'Row' field and sum of amount in 'Data field'.
If you refresh the data and select the required month you will get the desired information.
Sep 11, 2007 | Microsoft Office Standard for PC
Oct 21, 2016 | The Business & Productivity Software
874 people viewed this question
Usually answered in minutes!