formula to total then divide field
I have what seems like should be an "easy" problem to fix. I just cannot figure it out. But I know someone has ran into it before so I reach out to the oh-so intelligent community :) I have a sum...
Forum Discussion
Well it could be by week, or by month ... or by day I suppose. And they want to be able to choose the date range they are viewing. So if it's a report showing grouped by week, then it would only show the weeks they choose in a filter.
So daily, obviously my number is correct - when I start trying to group or summarize by week or by month, that is when the number doesn't calculate properly. and it is MADDENING at this point. OMG so freaking easy!!! We are trying to AVOID excel and promote the use of QB and things like this are exactly why people avoid it and keep emailing version 2389 of a spreadsheet that has grown to 934,012 records - some of which may or may not have been updated in the last version.
and just FYI - the numbers can change - so i'll be updating them probably weekly (So it's not like I can get several weeks worth of #s figured out in excel and then just import them into a table... the calculation needs to be performed and WORKING directly in the report. There HAS To be a way to do this!!
So daily, obviously my number is correct - when I start trying to group or summarize by week or by month, that is when the number doesn't calculate properly. and it is MADDENING at this point. OMG so freaking easy!!! We are trying to AVOID excel and promote the use of QB and things like this are exactly why people avoid it and keep emailing version 2389 of a spreadsheet that has grown to 934,012 records - some of which may or may not have been updated in the last version.
and just FYI - the numbers can change - so i'll be updating them probably weekly (So it's not like I can get several weeks worth of #s figured out in excel and then just import them into a table... the calculation needs to be performed and WORKING directly in the report. There HAS To be a way to do this!!