What's wrong with this derived field????

christimess · May 24, 2005

Hi,
I am trying to create the following derived field:
SUM(DISTINCT CASE "PS_AL_CHK_HRS_ERN"."ROW_NBR" WHEN '1' THEN "PS_AL_CHK_HRS_ERN"."AL_HOURS" ELSE 0 END)
but it keeps giving me the error message "ORA-00932: inconsistent datatypes: expected NUMBER got CHAR"
It is an Oracle database.
Thanks!

dlblack · May 25, 2005

You might try removing the quotes from '1' or add quotes to 0 for your compare.

David L. Black Consulting

christimess · May 30, 2005

I tried that but it did not work. I can't figure out what is wrong with it. I have delt with many derived fields like this, but I have never had this many problems with it before.

CharlesCook · Jun 5, 2005

I think ROW_NBR is a numeric field. Just to humor me make '1' 1 only. But leave 0 the way it is

SUM(DISTINCT CASE "PS_AL_CHK_HRS_ERN"."ROW_NBR" WHEN 1 THEN "PS_AL_CHK_HRS_ERN"."AL_HOURS" ELSE 0 END)

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

What's wrong with this derived field????

christimess

Programmer

dlblack

MIS

christimess

Programmer

CharlesCook

Programmer

Similar threads

Part and Inventory Search

Sponsor