Carolee
I use "iif" or "case" statements to eliminate unknowns. In this case
the statement like "iif(payhrs > 8, payhrs - 8,0)" should work. You
can also ignore unknown values when you aggregate your present
calculation. That's under "options" when you are editing the field.
HTH
RRD
I use "iif" or "case" statements to eliminate unknowns. In this case
the statement like "iif(payhrs > 8, payhrs - 8,0)" should work. You
can also ignore unknown values when you aggregate your present
calculation. That's under "options" when you are editing the field.
HTH
RRD
On 6 Jun 2001, at 8:26, Carolee Elder wrote:
> This is a question for all you Report Builder Guru's out there......I have a
> calculated field on my report the takes the payhrs-8.00 to calculate the
> daily overtime hours, but if they don't have 8.00 hours it returns ????? (I
> went into the calculated fields properties and set it to include positive
> numbers only and to set unknown values as 0) but now instead of the negative
> #'s it's giving me the ?????. How can I make it return a zero or blank in
> those cases so that I can do a summary of the calculated field? Hope this
> makes sense, Thanks in advance for any help :)
>
>
>
> To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com