Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crosstab value issue

Status
Not open for further replies.

Oscar115

Technical User
May 21, 2010
30
US
Using Crystal XIr1

I have defined the following formula Percent Paid:
{@sum of code 11 per amp}/({@Sum of code 01 per amp}+ {@sum of code 10 per amp Variable})*100

where @sum of code 11 per amp is:
sum({@Paid 11 per code}, {lrunit.cAmpkey}) and
@Paid 11 per code is:
if ({lrtran.ctrancode} = '11') and {lrtran.dtrandate} in {?Reporting Begin Date} to {?Reporting End Date}
then {lrtran.namount}

where @Sum of code 01 per amp is:
sum({@Billed 01 per code}, {lrunit.cAmpkey}) and
@Billed 01 per code is:
if {@Rent Billed Code 01} = True and {lrtran.dtrandate} in {?Reporting Begin Date} to {?Reporting End Date}
then {lrtran.namount}

where {@sum of code 10 per amp Variable} is:
shared numbervar sumofcode10peramp;
sumofcode10peramp := sum({@Billed 10 per code},{lrunit.cAmpkey}) and
{@Billed 10 per code} is:
if ({lrtran.ctrancode} = '10' and {lrtran.crefno} startswith {@Month Number Description} and {lrtran.namount} > 0.00)
or
({lrtran.ctrancode} = '10' and not ({lrtran.crefno} startswith ["01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12"]))
then {lrtran.namount}

The value of Paid Percent and all associated values are correct in the detail of the report.

I have inserted the @Paid Percent in the crosstab as Weighted ave of @Paid Percent with Calculate this summary setting: Weighted average with @Paid Percent.

The value displayed in crosstab does not match the calculation in the report.

Any help would be appreciated
Oscar
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top