Hello,

This seemed easy enough but I am struggling and would really appreciate some help.

I am trying to create a crosstab for how many days it took to complete an order. These are the formulas I created (the first part is the name of the formula):

1) days took to close - Date difference in days (d) between date ordered and date closed
2) < 20 - if {@days took to close) < 20 then 1
3)< 40 - if {@ days tool to close) >= 20 and {@ days tool to close) <= 40 then 1
4)> 90 - if {@ days tool to close) > 90 then 1
5) {@<20} + {@<40} + {@>90}

In the cross tab I pulled in formulas 2, 3, 4, 5 mentioned above under the summarized fields (which displayed it as sum of ....)
Nothing at all in the rows and columns field in the cross-tab query expert.

In the report design, I manually added labels for the 3 different rows as: < 20, <40 and >90

So far so good. But tried a lot and I am not able to create percentages that work (tried so many different things).

There is no grouping in the report as there are no details. We just need a cross tab with totals and percentages. And a chart which I will worry about later.

Thank you,

Pam

You are right. May I rephrase my query. Since a couple of items have changed.

Say I have a formula field to calculate the days between order taken and last time it was sent for closure. There are several dates for closure and only the last one in the table is relevant so the formula is:

1)maximum ({table.field}, table.id}) - {date created}

then I want:
2) total closed in given time range - can be down on report itself
3) count of days < 20 and the percentage of total
4) count of days > 20 and < 50 and the percentage of total

When I try to use the formula with maximum I am unable to do a count. What can I do to calculate #3 and # 4 above.

Thanks much

Thank You 'freestylepunk'