calculated

Hi, I've created a pivot chart of 2017 and 2018 sales across four categories, by each 4 week period. I needed to add a total to the pivot chart, and the simplest way I found to do that was inserting a calculated item of all 4 ranges and calling that the total. This adds a line which is...

Hi all, I got this setup but can't figure out how to get the total amount of time from column C to column D. <colgroup><col><col><col><col></colgroup><tbody> Row Labels Count of Shipment Min of Tid Max of Tid Person A Trp2 1 10:48:00 10:48:00 Trp3 4 12:29:00 16:52:00 Trp4 7...

Hello, I'm having some difficulty with the SUBTOTAL function. I'm looking to find the sum of a range within a filtered spreadsheet. I entered =SUBTOTAL(9,[RANGE]) and it returned an answer of 7.10543E-14 (which doesn't make sense since my values on have two decimals). I calculated it manually...

Hi, I have a query that I am building where I have a calculated field (within the query) that I want to use to calculate a final value in another column. I cannot get this to work using to columns first would be the first calculation then the second would be the simple math equation. See...

Hello all, I have a question when using calculated fields in pivot tables. I have a set of surveys, where each number means either negative, null, or positive. What I want the calculated field to do is the following formula: (count of all positives - count of all...

Hello, I'm a little frustrated with myself for not being able to find a solution for this issue. In my worksheet, I have a start date (F29) and a completion date (H29) calculated from a task duration time that references a calendar of dates above (T9). The formula I have is...

I have 3 calculated items in a pivot table - each just sums 3 or 4 other items from the field. Some of the items are summed in multiple calculated items. For example: 'Subtotal1' = 'Item 1' + 'Item 2' + 'Item 3' and 'Subtotal2' = 'Item 3' + 'Item 4' + 'Item 5' Twice now the formulas seem to...

I'm trying to use a Pivot Table Calculated field formula of IF(Column 50>20,"YES","NO"). It is only returning #VALUE . The formula works when I change the return values to numbers. Is it not possible to return text from a pivot table calculated field?

Hi guys, I understand that we do not have Calculated Fields in Power BI, so is there any way to emulate the function through adding new calculated columns in Power BI? Basically, the Calculated Field that I had back in excel is "(Target Revenue - Actual Revenue)/Actual Vol", referencing three...

Hi all, I haven’t been able to find an answer on this. I have apivot and I need a calculated item to consider the value in the previous column.Meaning: if Columns G and H were June and July respectively, I need the calculateditem result in Col H to consider a value in Col G in the math. Is...

I have a formula field in an access table which basically combines 2 fields. However, the calculated field changes the number field to remove the zeros. Is the below possible? <tbody> Letters Numbers What the Calculated Field shows What I want the calculated field to show AA 0001 AA1 AA0001...

Hi there, I'm utilizing powerpivot to perform cost center allocation. I have a transaction table which was loaded to data model and another table containing % of allocation to each receiver cost center # was loaded to data model as well. Required relationship was established using cost center #...

Hi, I have a PT with 4 years of data in it. I'm creating calculated fields to show the difference in sales and % of difference in sales for 2017 and 2018. Those are the only two years I'm showing in the report with Year being a column value. Because I want to see the difference in sales...

Dear All, I am trying to get result between two dates for the period from 01.04.2017 to 31.03.2018. Could you pls. help me to resolve. I used the Datedif function but could not acheived. Thanks in advance. You may refer remark for understanding. Thanks in advance...

Dear experts. I am new to Excel Macro and I would like to create an Excel Macro programming code so that it will unhide/hide one certain page based on a calculated cell value. More specifically, I would like to find a value "B1-A1" (A1 and B1 are dates), with a conditional statement on "C1"...

Hello I can't get Excel and the Pivot I have made, to use the running total (the accumulated sum) when I am trying to use it in a calculated field. Does anyone know a way to make a calculated field, that uses the running total in calculating something else in a pivot? Or is there another way to...

I have a field where the data type is Calculated Left([Emp_LastName],5) & Left([Emp_FirstName],2) FYI This creates a UserID. I want this is be the default but let the user make up a 5 character one if they choose. whats the best way to do this?

I'm looking for a macro that I can use to create two calculated fields on a pivot table - I have to create these upwards of 10 times every day! The first one would be called "Conversion Ratio": ='Hits Unique' /Signups And the second one would be "Rev per Sale" ='Initial Revenues /...

Hi Guys, I was wondering if anyone has any ideas on a problem i have. I have a pivot table with data and want add 2 calculated fields to the data. My raw data has requirements and receipts and current stock including cost for each material. I want start by taking the stock of the material and...

I want to round the number for the decimal part 0.6, e.g if the calculated is 4.6 or 7.79 it rounds up, otherwise if the calculated is 2.5 or 9.43 it would round down. Can anyone help me?