calculaing field

I built this sheet years ago for a colleague. However, human error seems to be the main issue. I need to be able to push the data from the Daily Sheets and push it to Well Summary. The sheets are going to be dynamic in the sense that we don't know when or how long a run will last, so it almost...

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 All! I'm a bit new to this, so any help would be highly appreciated! I have a Few Tables, Mainly the "Highlighted below" are my 2 (soon to be 3) primary data tables, Harvest TIME has "time" expenses, Harvest Expense the "Software" Expenses (and dates of the expenses), and later i will be...

Hi Dears, This is pushing me crazy, sounds so simple but it is not working out! I want to filter the top N calculated values in a pivot table, but it keeps filtering the top data point values! For example, below is my pivot table added the "Amount" Field again to the Values section >>...

Hi, I tried different steps two subtract two times (cell b-cell a) using calucated fieldd and output the total in cell c but my output is totally wrong. Could someone look into this for me. Much appreciated. Shall I upload sample file? Thank you

Hello, I am currently working on a form which has a "comments" box for people to update. We like the data entry guys to use a specific format of the date and time and their initials and then the comment. Unfortunately they don't always do this properly and miss out some details and have a...

Hi, I am using Excel 2013. I have been looking everywhere to resolve this issue but to no avail. I have a Pivot Table that looks like this : Country | Data | Percentage | UAE | 620 | | | 130 |...

I am trying to insert a calculated item on my pivot table that calculates the Profit margin. I have two columns Revenue and Expense. The calculated column would look like this = (Revenue-Expense)/Revenue. However no matter where I click in the pivot table both the Calculated Field and Calculated...

Hello everyone. I have a pivot table that has two columns that contain dates. I am trying to add a column with a OR formula that returns true or false base on whether the first date is equal to the second date OR the first date +1 equals the second date. The formuala I use is...

I am using a query that compares two fields from a large db. This I can do. What I would like to do is - have a calculated field that tells me the number of matches found so I then can perform other calculations such as averages or percentages Etc. In Excel I use the Count or CountA functions...