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
![[elephant2] [elephant2] [elephant2]](/data/assets/smilies/elephant2.gif)
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
![[elephant2] [elephant2] [elephant2]](/data/assets/smilies/elephant2.gif)