MySQL Forums
Forum List  »  Newbie

Re: SUM IF totals help
Posted by: Andrew Adcock
Date: February 03, 2010 02:31PM

I should note that perhaps my problem is in the way I am storing the select_month data. currently I am saving that as a string which I allow the user to select from a multi-select. So a field record might look like
"01,02,03,04,05" for one row and "01,02" for the next.

This complicates my query because I need to apply the budget_amount to each month inorder to sum properly.

Options: ReplyQuote


Subject
Written By
Posted
February 03, 2010 10:24AM
Re: SUM IF totals help
February 03, 2010 02:31PM
February 03, 2010 03:19PM
February 03, 2010 07:57PM
February 04, 2010 04:10AM
February 04, 2010 06:12AM
February 04, 2010 07:57AM
February 04, 2010 08:35AM
February 04, 2010 09:12AM
February 04, 2010 10:02AM
February 04, 2010 10:19AM
February 04, 2010 10:26AM
February 04, 2010 11:06AM
February 04, 2010 12:52PM
February 04, 2010 07:12PM
February 04, 2010 06:53PM
February 04, 2010 02:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.