[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
Solved

# Using calculated time ave to create a Pivot Table

Posted on 2013-12-10
Medium Priority
142 Views
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
Question by:Rrave26
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 81

Accepted Solution

byundt earned 400 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

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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
###### Suggested Courses
Course of the Month13 days, 6 hours left to enroll