last detail row adding twice to gf formula 1

[bmacdo]

This feels like a newbie error, but ...

I created two formulas to conditionally tally columns. I didn't use a Running Total or Sum as I want to later compare the formulas to create percentage.

In the last detail line in the first column I am counting by formula, the condition is not met and a zero appears. The total in the gf is correct. In the same line in a second formula column, the condition is met for a 1. In the gf formula for that column, an extra one is added. I copied the record key into to the gf to verify it is the last record being counted twice.

The formulas go something like this:

OutOfPolicy
-----------
WhilePrintingRecords;
numbervar OutOfPolicy;
If {db_call.call_length} > 30 and
{db_policy.policy_date} > Date(2006,07,01) then
1 else 0

OutOfPolicyCtr
--------------
WhilePrintingRecords;
numbervar OutOfPolicyCtr;
OutOfPolicyCtr := OutOfPolicyCtr + {@OutOfPolicy}

DisplayOutOfPolicyCtr;
----------------------
WhilePrintingRecords;
numbervar DisplayOutOfPolicyCtr;
DisplayOutOfPolicyCtr := OutOfPolicyCtr

WithinPolicy
------------
WhilePrintingRecords;
numbervar WithinPolicy;
If {db_call.call_length} <= 30 or
{db_policy.policy_date} <= Date(2006,07,01) then
1 else 0

WithinPolicyCtr
---------------
WhilePrintingRecords;
numbervar WithinCtr;
WithinPolicyCtr := WithinPolicyCtr + {@WithinPolicy}

DisplayWithinPolicyCtr;
-----------------------
WhilePrintingRecords;
numbervar WithinPolicyCtr;
DisplayWithinPolicyCtr := WithinPolicyCtr

Thanks for any and all help.

Brad

 

[bmacdo]

p.s. the same over count occurs if I take out the groups and place the display formulas in the report footer after selecting on one group.

 

[lbass]

You should set them up like this:

WhilePrintingRecords;
numbervar OutOfPolicy;
numbervar OutOfPolicyCtr;
numbervar WithinPolicy;

If {db_call.call_length} > 30 and
{db_policy.policy_date} > Date(2006,07,01) then
OutOfPolicy := 1 else
OutOfPolicy := 0;
OutOfPolicyCtr := OutOfPolicyCtr + OutOfPolicy;
if OutOfPolicy = 0 then
WithinPolicy := WithinPolicy + 1;
OutOfPolicy;

//{@DisplayOutOfPolicyCtr} for report footer:
whileprintingrecords;
numbervar OutOfPolicyCtr;

//{@DisplayWithinPolicy} for report footer:
whileprintingrecords;
numbervar WithinPolicy;

You could probably do this much more efficiently with conditional formulas and still be able to use them in calculations.

-LB

 

[bmacdo]

Wonderful! That worked. Thanks very much!

Brad