I have reattached your workbook with the what I think is the desired view. Instead of using two separate calculations for RFP and Bid/Proposal, I created 1 calculation that combines the two--then filtered out the NULL values.
Then, the datediff calculation was created to use the previous date (refer to Sheet 6). Then, how it is computed needs to be adjusted (right click on it on the text shelf and select Edit Table Calculation to see how it's being computed).
Hope this helps!
Dates Ghant.twbx.zip 74.3 KB
1 of 1 people found this helpful
Yes, that is exactly what I was looking for. Is there anyway to get both the RFP Issued and Bid/Proposal Dates to display in the tool tip, it currently displays the RFP Issue date twice.
Nice work, thanks!
I was working on it again this morning and have a couple more questions.
The bars are displaying as I want but the DATEDIFF counts look to be repeating on the bar
Opp ID 00000002
RFP Issued 05/02/2012
Bid/Proposal Due 11/29/2012
DATEDIFF identifies 211 days (excel calculates 207) however when you click on the bar you have 2 sections in it, one has the correct DATEDIFF range and then the other section adds on another 211 days so the bar is ending in June 2013.
Some of the opps still have Nulls
Opp ID 20000024
RFP Issued 11/31/2012
Bid/Proposal Due 01/31/2013
DATEDIFF is returning a Null
I also need to sort it so the list displays by RFP Issue date so we can tell what opportunities will be in house for proposal at the same time so we can resource plan. I can only find a sort by Opp ID number.
Thank you in advance for your help.