Recent activity
Subscribe to this feed
Bryan Crotaz asked a question in CustomWare on January 04, 2010 17:31:
Failure of set-data and grouping reporter - bug?Grouping reporter gives zero result:
{table-data:DailyTimesheet}
|| Day || Start || Finish || Minutes || Location ||
| {date-data:Date|format=dd-MMM-yyyy|required=true|}today{date-data} | {date-data:Start|format=HH:mm|required=true|}now{date-data} | {date-data:Finish|format=HH:mm|}{date-data} | {set-data:Minutes}{report-on:injected=true}{report-info:data:Finish > date:milliseconds > - %data:Start > date:milliseconds% > / 60000}{report-on}{set-data} | {list-data:Location}{list-option}Office{list-option}{list-option}Home{list-option}{list-option}Travelling{list-option}{list-data} |
{table-data}
h2. Summary
{report-table}
{grouping-reporter:key=data:Date > date:d MMMM yyyy|as=Day}
{grouping-stats:data:Minutes|as=MinutesData}
{local-reporter:data:DailyTimesheet}
{date-sort:data:Date}
{local-reporter}
{grouping-reporter}
{report-column:title=Date}{report-info:grouped:Day}{report-column}
{report-column:title=Total Mins}{report-info:grouped:MinutesData > stats:sum|format=#.#}{report-column}
{report-empty}_No data has been entered yet._{report-empty}
{report-table}
1. The total mins column shows 0 regardless of input data
2. How can I change the total mins to divide by 60 and show hours with one decimal place?
Bryan Crotaz asked a question in CustomWare on January 04, 2010 16:40:
How to do time difference with report-on (or similar)?I have two time columns in a timesheet {table-data} row, Start and Finish.
I want to add a third column showing hours (Finish-Start). I've used a previous answer to do it with {report-on} and divide by milliseconds, but it doesn't seem to allow an result other than integer. I'd like to show one decimal place. Is there a way to do this?
Loading Profile...

