| Calculation error [message #403759] |
Mon, 18 May 2009 09:10  |
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  |
cookiemonster
Messages: 13958
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:
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
