Calculation error [message #403759] |
Mon, 18 May 2009 09:10 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
aarti81
Messages: 235 Registered: December 2007 Location: USA
|
Senior Member |
|
|
Hi all
In the report i have the following fields
contractor_type contractor_name
1 ABC
2 A22
1 BER2
1 CCC
2 HPA
But when i add a new calculation
case when 1585.Contractor Type=2 then ARRA1585.Contractor Name=null else 1585.Contractor Name
I'm getting the following error:error in formula-unexpected end of formula
syntax error at token position 66 and highlites the '=' ,any help is greatly appreciated
thanks
|
|
|
Re: Calculation error [message #403766 is a reply to message #403759] |
Mon, 18 May 2009 09:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
CASE checks one or more BOOLEAN expressions (the when bit) and returns one or more values as appropriate (the then / else bit).
this:
then ARRA1585.Contractor Name=null
Is a BOOLEAN expression. Case can not return Booleans.
I suspect that it should be just this:
|
|
|
|