The summary / running total field could not be created

[camellia2000]

The following is a Crystal Reports issue I’m having:

First -
I created the following formula called @YEAR:

mid({DATE}, 1, 4)

(Date is a string field with a length of 8. Ex. 20031229)

next -
I try to create standard deviation formula called @Ins Stnd:

StdDev (Count ({FILNBR}, {@YEAR))

( FILNBR is also a string)


but when I try to save the 2nd formula, I get the following error msg:

The summary / running total field could not be created

Can someone help me? I would appreciate it very much. Thank you.

 

[checkai]

I would say that they'd have to be converted to numbers...not strings...

toNumber({@Year})

 

[dgillz]

You cannot summarize a value that is the result of a summary operation. Both StdDev() and Count() are summary functions. Take a llok at running total fields, or more likely, using variables to calculate this value.

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

http://www.trianglepartners.com

 

[camellia2000]

Can i get an example based on the formulas that are provided?

 

[synapsevampire]

What does "based on the formulas that are provided" mean?

Your formula won't work, and there were no formulas offered.

Here's a CD whitepaper that shows how to manually calculate a SD:

http://support.crystaldecisions.com/library/kbase/articles/c2007430.asp

You can use the count() (and other functions) alone, just not nesting them.

Also, you can just use year({table.date}) to get the year, and it returns a number not a string.

-k

 

[synapsevampire]

Sorry, skip the date blurb, I see that it's not a date, it's a string.

-k