Decode function from Oracle to cognos

[mohammedhajat]

I have a decode sql from oracle, which i need to translate into a measeure into Cognos, it's fairly complex for an amatuer like me..

I know the equivalent is the Case function, but I cant seen to write the case equivalent of the decode, could anyone please assist?


Code:

 nvl(decode(totalcost,0,null,totalcost),
nvl(decode(submitcost,0,null,submitcost),
nvl(decode(apprvalue,0,null,apprvalue),
nvl(decode(defestvalue,0,null,defestvalue),0)))) as "COST"

 

[blom0344]

check the use of coalesce function..

Ties Blom

 

[mohammedhajat]

COALESCE(NULLIF(totalcost,0)
,NULLIF(submitcost,0)
,NULLIF(apprvalue,0)
,NULLIF(defestvalue,0)
,0) "Cost"

niceone,. thanks