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
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