summary follow up 1

[fsreport]

Hi -Lb
for some reason it resetting the count even when it the same territory
ex:
C01 on the first page the accum number start at 3 and end at 47
second page it start a 0 and ends at 50
third page start at 2 and ends at 48
page 3 start at 1 to 25
page 4 start 0 to 25
page 5 start 1 to 16


then the formula takes the number 16 from the last page and divided the sma
it should add all the number for that territory and not restting after new page


fsreport


fsreport

 

[fsreport]

Hi
got it figure
i had to uncheck gr territory keep together
sorry about that
tnaks afgain -LB
your the girl

fsreport

 

[RustyAfro]

isn't lb a guy?

 

[fsreport]

hi -Lb
now there adding a channel group
so i need to add the result from your previous post
//{@reset} to be placed in the territory GH:
whileprintingrecords;
numbervar cntforterr := 0;

//{@accum} to be placed in the contact ID group footer:
whileprintingrecords;
numbervar cntforterr := cntforterr + {#GroupCount};

//{@display} to be placed in the territory group footer:
whileprintingrecords;
numbervar cntforterr;
sum({@SaleSMA}, {table.territory})/cntforterr

i have to take the
sum({@SaleSMA}, {table.territory})/cntforterr
from the display

and applied it to the channel
so i need so add the the @display formula at the channel level

Thanks



fsreport

 

[lbass]

You need a new variable for this. Create a new reset formula, and as I recommended in your other post, change it to:

//{@resetchannel} to be placed in the channel GH:
whileprintingrecords;
numbervar cntforchannel;
if not inrepeatedgroupheader then
cntforchannel := 0;

Change {@accum} to:
//{@accum} to be placed in the contact ID group footer:
whileprintingrecords;
numbervar cntforterr := cntforterr + {#GroupCount};
numbervar cntforchannel := cntforchannel + {#GroupCount};

Then create a new formula to display the result in the channel group footer:

//{@displchannel}:
whileprintingrecords;
numbervar cntforchannel;

-LB

 

[fsreport]

hi -LB
thanks for the replied
as for the @Display

do i need to add this to it
//{@displchannel} to be placed in the channel group footer:
whileprintingrecords;
numbervar cntforchannel;
sum({@SaleSMA}, {table.channel})/cntforchannel

or leave it the way you done it?

Thanks so much
PS if your close to NY i would by you lunch

You made my day

fsreport

 

[lbass]

Yes, you can build in the calculation into the display formula.

-LB

 

[fsreport]

hi -Lb
thanks
now if i want a grand total
all i need it to add both record return from territory and channel right?


fsreport

 

[lbass]

Please lay out all requirements in the beginning post, instead of adding them on piecemeal. For the grand total, create another variable, and add it to the accum formula, just like the others. Then create a new display formula for the report footer, with no reset formula.

-LB

 

[fsreport]

thanks a million -LB
sorry for putting piece by piece.
the client is asking changes at last minutes



fsreport