Liveware Publishing Support Forum

I cannot seem to get totals for my financial data by month and year. Do you have an example I could mimic? The raw data is by date-time.____I have created "month" and "year" groups but then get bamboozled when I try to total by month and year.____Thanks.

You should be able to sort the report by the datetime field and then group by a calculation that takes the YEAR() of the date and then a second one that takes the MONTH() of the date as long as the base field is really date or datetime and not character. If it is character, then it would require different calcs but certainly could be accomplished.____Kathleen__R&R Support