Cross Tab - Embedded Summary - CR2011

[Former Member]

Hi all

I'm a newbie to Crystal so am sure that I am missing something glaringly obvious.

I have a crosstab that shows a persons activity for each given day that then summarises by week, month etc..

Within the row totals I have some crisitcal information. I have then added an embedded summary withing the totals section in a bid to identify the number of hours a person is spending in the office per day

Date                    Contracted Hours    Shift Start    Shift End    In Office Hrs

01/10/2012        07:15:00                        08:00:00    17:00:00    09:00:00

02/10/2012        07:15:00                        08:00:00    16:30:00    09:00:00  <- this should be 08:30:00 not 09:00:00

The shift start time = minimum ({@task_start_time_seconds})

The shift end time = maximum ({@task_end_time_seconds})

In office Hrs - Embedded Summary      = maximum ({@task_end_time_seconds}) - minimum ({@task_start_time_seconds})

What am I doing wrong. Is it because I am using an embbeded summary incorrectly?. How can I correctly calculate the in office hours in the totals section of the cross tab.

many thanks

an incredibly frustrated Stewart

[abhilash_kumar · Accepted solution]

Hi Stewart,

If you're using this formula:

maximum ({@task_end_time_seconds}) - minimum ({@task_start_time_seconds})

to calculate the "In hours", you'll always get 9:00:00 hrs, nothing else.

You need to refer to the row and column indexes to find out the Shift Start and Shift End and then display that value in the Embedded Summary for that row.

I don't know the complete structure of your cross-tab, otherwise I could have helped you with the formula.

Could you please attach the report with saved data; that way it'll be more easier for me to get back to you with the solution. Before you attach the report, please change its extension to .txt.

- Abhilash

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

[Former Member · Accepted solution]

Hi Abhilash

Thank you for your response. I understand what you mean but have no idea where to start with the row column indexes.

Any help that you can provide with the calculations would be really appreciated but unfortunately I cannot get the .txt file to attach. I will keep trying.

many thanks

Stewart

[abhilash_kumar · Accepted solution]

Hi Stewart,

I would need the report itself, so that I can help you with a definite solution.

If you're having trouble attaching it to this thread, please e-mail it to me.

- Abhilash