Yes. Sum(Case …End) in a measure select statement worked.Thanks.
Dave, I have gone through your thread about Object Projection and aggregation. I did not understand it. I will read it again. Can you please give the basic difference in one line or as simple as you can?
But how to write the object SQL for the following MTD YTD Measures
Users prompt for the date range date1 and Date2.According to that I have to calculate MTD and YTD. The query in the above thread has hardcoded dates. Instead of that it has to take the user date range. There is no Object level SQL. I have not written anything yet
BOBJGuy 
(BOB member since 2010-02-25)