calcuated field

I have a pivot table and I have two numerical fields call enrol and total. I want to create a % of enrol by dividing enrol by total. Which is fine, but if enrol or total has 0, then #value is being returned. Rows in the Pivot Table is Location and columns has Main. I've tried the following...

Hi Team, I am trying to create a price calculator. It is a bit tough and i am not good at these complex logics. kind of subscription model. Can you please help. Logic : 1. Select a product ( there are 10 different products) 2. Select the type of agreement ( three are 5 different options) 3...

Desperation brought me here, as I'm banging my head against a wall trying to figure out why I can't insert a calculated field or item that would allow me to show a running remaining balance for vendors using a pivot chart. I've attached an image to show the basic set-up I've got. Ideally the...

Hello All, I am trying to create a calculated field in a pivot table so that i can find the variance between the current years beginning account balance and the prior years ending account balance. <tbody> A B C D E F G H I 1999 1999 2000 1999-2000 2000 2001 2000-2001 001 Beginning...

Hi all, Newbie to the forum here. Wondering if it is possible to include a Named Range within a Calculated Field in my Pivot Table. The Named Range is "Period". Essentially, I require a calculation which looks at the field "Actual Entered Amount" / "Period" * 12. This field would then be...

Hi, I have a very simple "difference" calculated item in my pivot table. The problem is it freezes, every single time I change any field in the pivot. The background data isn't very large and the formula very simple. Any idea's why this might be happening? Any ideas how to fix it? Thanks,

I need to count clients served each day. I want to only count a client one time even if they have multiple services in one day. I have a formula that works in Excel I have Column A is a date field and Column B is Client ID =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))>1,0,1) <tbody> Date...

Hi, I have numbers of employees and their performance %. I need to find out the % a team is meeting the target. Say if target is 70%. I need to first count how many employees in Team A is meeting 70%. Then I am dividing that number with the total employees in the Team A. This will get me the...

Hi I’m currently trying to work out the difference of two valuations (internal and external) in a pivot I have created. Currently my Pivot is arranged as follows, source data (internal or external) as column labels, Product as row labels with a further break down by office region of...

<tbody> Count of client Count of attended Count of FTA Sum of Field1 498 327 171 #DIV/0! 741 516 225 #DIV/0! 243 186 57 #DIV/0! 326 218 108 #DIV/0! 609 453 156 #DIV/0! 39 18 21 #DIV/0! 365 292 73 #DIV/0! 2821 2010 811...

OS: Windows 7 MS2010 Is it possible to have a range of cells, with formulas that can be prevented from calculating, while the rest of the workbook is in calculation mode?:confused:

Hi all, I have a pivot, top line of which looks like: Name Count of Day Total Time Joe Blogg 2 180 Using calculated fileds, i'm tring to add a 4th field which will divide Total Time (which is a sum), by Count of Day (which is count)...

What I am trying to do: - Create an add-in that does a simple extended cost calculation = (unit_cost) x (units_per_pack) x (packs_per_carton) - I want the calculation to be based on the column header (always in row 1) rather than column A, B, or C because in different spreadsheets the columns...

I have a pivot table that looks like this: productname impressions cost CPM product1 1,000,000 4523 4.7 product2 5,000 2400 48.45 product3 3,000,500 6,000 3 CPM is a calculated field that uses the formula...

I have some calculated fields in my pivot table I no longer need because they are incorrect and I would like to delete them. I have tried to select the pivot table and then click formulas and then calculated field and select the name of the calculated field however the delete button is greyed out.