Solved

Using calculated time ave to create a Pivot Table

Posted on 2013-12-10
2
123 Views
Last Modified: 2014-01-06
I have a spreadsheet where I've calculated the time to send out a form via a formula, if(sum(b2-a2)>0, sum(b2-a2), 0).  

Can I use this calculated field in a Pivot Table where I can ave these times?
0
Comment
Question by:Rrave26
2 Comments
 
LVL 80

Accepted Solution

by:
byundt earned 100 total points
ID: 39710579
Did you try creating a PivotTable and encounter trouble? It ought to work even if one of the columns gets its values from a formula.

I also suggest you consider this formula as an alternative to your IF & SUM formula:
=MAX(0,B2-A2)
0
 
LVL 39

Expert Comment

by:Pratima Pharande
ID: 39710585
I aslo thought there is no problem in doing that.
Can you share your excel with dummy data with us so that it will more clear
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now