Multi-Fractional Report

[Genx]

Hey all,

Here;s the issue, i need to produce a report such as the following:

Sex - Male________100 (50%)

BREED 1 = 5 (5%)

Andy

Will

Ashley

BREED 2 = 55 (55%)

John

Brendan

...

BREED 3 = 40 (40%)

Joshua

William

...

Sex - Female________100 (50%)

BREED 1 = 10 (10%)

Laura

Willma

Ash

BREED 2 = 50 (50%)

Joanne

Brenda

...

BREED 3 = 40 (40%)

Lianne

Jo

...

And so on, i'm just having problems figureing out how to get the percentages of a particular subsummary - anyone lend a hand?

Cheers,

~Genx

Edited July 2, 2006 by Guest
Didn't make sense

[John Mark Osborne]

Looks like you are having trouble with the Fraction of Total option on a summary field. It will only work with totals and it looks like you are counting categories. For this, you can use the GetSummary function. I have included a database with similar data to yours that demonstrates how to create the formulas.

Breeds.fp7.zip

[Genx]

Your a legend John,

Thanks

~Genx