Creating Summarzied Percentages on a Cross-Tab Report

[ChiTownDiva]

I'm creating a cross-tab report with the following:

Columns:
Regional Vice President
Zone

Rows:
Product Type

Additional Fields:
Quote IDs

Summarized Fields:
Sum of Quote-to-Order$ (per product type)
Avg of Quote-to-Order$
Count of Quote IDs

I need to add a summarized percentage field for the following scenario:

Salesmen in the Carolinas (zone) quoted $130,776 worth of product XYZ. The total quoted for product XYZ in the entire country was $9,357,932. The percentage that the Carolinas quoted was 1.39%.

In plain english $130,776/$9,357,932 * 100 = 1.39%

Do I write an if-then-else statement in the formula editor? How do I write it?

Thanks.

 

[kenhamady]

Cross-tabs do not allow formulas. The only way to do this is a manual cross-tab, which means hard coding the columns. See the FAQ on common formulas and look at #12. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[ChiTownDiva]

I created a report a few weeks ago where I had to count the number of leads yeartodate, weektodate, etc.

I created the formula with the formula editor and added the formula to the report. I then went back into "Format Cross-Tab" and made it a summarized field.

The formula was:

If {Mktg_Leads.Date_Received}in YearToDate
Then
1
Else
0

I want to do the same thing, but create a Percentage formula.

Thanks.

 

[kenhamady]

Please read the FAQ mentioned above. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[ChiTownDiva]

Are you're speaking of the Example Formula 12 in Help:

If (Average([{file.MON1}, {file.MON2}, {file.MON3}]) -
{file.CURRENTMON})> 0 Then
Minimum([.25*((Average([{file.MON1}, {file.MON2},
{file.MON3}) - {file.CURRENTMON}]), 10000])
Else
0

 

[kenhamady]

No I am referring to:

http://www.kenhamady.com/form12.html

You can get to this through the FAQ area of Tek-Tips, but here is the direct link. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)