Formulas Showing in Sum Option

[jconway]

I'm trying to summarize a formula field, but it doesn't show in the drop-down. The field is an integer, and I know there's just something I have to do like add WhilePrintingRecords or something to the beginning to make it eligible to be summarized. Can someone remind me of what I'm missing?

 

[dgillz]

Please post your formulas. And do not cross post.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[jconway]

if ({#AcctSeq}=1 and not({Command.SINACT}='Y' and {Command.STFLAG}='Y'))
then {Command.GPLACE}
else 0



if ({#AcctSeq}=1 and {Command.SNPYLB}='Y')
then 1
else 0

I wasn't intentionally cross posting, I just realized I had put my post in the wrong forum.

 

[jconway]

I just changed my formulas to not use cross-tabs as I thought this was the issue but it's not.

if ({@AcctSeq}=0 and not({Command.SINACT}='Y' and {Command.STFLAG}='Y'))
then {Command.GPLACE}
else 0

In this formula, I'm checking to make sure accounts aren't dups, and then I use the dollar value (Command.GPLACE). Otherwise I pop a 0 in.

 

[dgillz]

Please post your formula for {@AcctSeq}, and any formulas it references as well.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[jconway]

Maybe it will be easier to ask for help in what I'm doing. I have a report full of data (surprisingly). I have multiple lines for each account, because every payment on an account has it's own line. I'm trying to summarize the List $ Value. However, because there are many lines with the same value, what I've done is add a field to count the records for each account. I'm then trying to summarize only the fields with Count #1. I'm not sure if there's a better way to do this, but this is what I have.

@AcctSeq Formula:

numbervar AcctSeq;
if onfirstrecord
then AcctSeq:=0
else if {Command.GACCT#}<>previous({Command.GACCT#})
then AcctSeq:=0
else AcctSeq:=AcctSeq+1


AmountPlacedFormula (The formula I'm trying to do a grand total on):
if ({@AcctSeq}=0 and not({Command.SINACT}='Y' and {Command.STFLAG}='Y'))
then {Command.GPLACE}
else 0


Basically, if my sequence # is 0 and a couple other fields don't show a 'Y', then I want my placement amount. Otherwise I want a 0.

Hopefully I've given enough detail here...

 

[dgillz]

Please show sample data and desired results rather than trying to explain what you want.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[lbass]

Use a variable to summarize this, as in:

whileprintingrecords;
numbervar sumgplace := sumgplace + {@AmountPlacedFormula};

In the report footer, use:
whileprintingrecords;
numbervar sumgplace;

-LB

 

[jconway]

DAta:

Acct List Date List Bal Pay Date Pay AMt
1 2/1/08 $500 3/1/08 $200
1 2/1/08 $500 3/15/08 $300
2 2/15/08 $1000 3/1/08 $500
2 2/15/08 $1000 3/13/08 $750
2 2/15/08 $1000 3/30/08 $200


Summary Line
Feb '08
# Listed $ Listed # Paid $ Paid
2 $1500 2 $1950

 

[lbass]

You just need to use a running total that sums List Bal. In the evaluation section, use a formula like:

(
onfirstrecord or
{command.gacct#} <> previous({command.gacct#})
) and
not({Command.SINACT}='Y' and
{Command.STFLAG}='Y'))

Reset Never.

-LB

 

[dgillz]

2 running totals, one on Acct, make it a count summary operation, evaluate on change of field acct, reset=never.

the second on Bal, one on Acct, make it a sum summary opration, evaluate on change of field acct, reset=never.

A simple sum on pay amt.

Hide the details section. That should do it.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?