-
1. Re: Table Calculation Help Needed for a Newbie
Shawn Wallwork Jan 4, 2012 3:35 PM (in response to jasonmischel0)Hi Jason, I thought I saw this question got answered, but now the forum is showing zero responses. Did you get an answer? Or did you figure it out? If not, post a sample workbook of what you've go so far and I'm sure you'll get an answer -- the problem doesn't sound that difficult (but then what do I know). --Shawn
-
2. Re: Table Calculation Help Needed for a Newbie
jasonmischel0 Jan 5, 2012 11:50 AM (in response to jasonmischel0)Shawn,
Thanks for the response. I have not received a response yet. I have attached a copy of the data and you can see that I am able to make the calculation that I want for any given date in time without using a table calculation. However, what I want to do is make this calculation for every Monday starting with a given date. Hopefully that can be accomplished with a table calculation.
Thanks,
Jason
-
3. Re: Table Calculation Help Needed for a Newbie
Shawn Wallwork Jan 6, 2012 6:31 AM (in response to jasonmischel0)Jason, I worked on this several hours last night and couldn't come up with anything workable. Sorry it's beyond my skill level. Maybe Joe or Richard will jump in. --Shawn
-
4. Re: Table Calculation Help Needed for a Newbie
Richard Leeke Jan 7, 2012 8:52 PM (in response to jasonmischel0)The way I would tackle this would be to modify the data source and add a table listing the dates of the Mondays - and define a cross product between that and your existing table. The answer will fall out easily then.
I don't think you can do it just with table calculations off your existing data source - though as always, I'll be happy for Joe to prove me wrong.