Hi,
I'm currently using the following formula to work out the number of days between query status changes, here's the formula:
datediff('d', previous({query_status_changes.date_changed}), {query_status_changes.date_changed})
The problem being is that this is apparently a summarized field, and I can't get totals based on my various groups from this.
I've tried using a cross tab, which will add the totals together, but not how I want them. I've also tried using tonumber which doesn't appear to have any effect. Is there another way of doing it?
I'm using SAP CR XI.
Thanks
Di
I'm currently using the following formula to work out the number of days between query status changes, here's the formula:
datediff('d', previous({query_status_changes.date_changed}), {query_status_changes.date_changed})
The problem being is that this is apparently a summarized field, and I can't get totals based on my various groups from this.
I've tried using a cross tab, which will add the totals together, but not how I want them. I've also tried using tonumber which doesn't appear to have any effect. Is there another way of doing it?
I'm using SAP CR XI.
Thanks
Di