Home » Developer & Programmer » Reports & Discoverer » Calculation error (disc 10.1.2)
Calculation error [message #403759] Mon, 18 May 2009 09:10 Go to next message
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 messageGo to next message
cookiemonster
Messages: 12403
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:
then null
Re: Calculation error [message #403788 is a reply to message #403766] Mon, 18 May 2009 13:04 Go to previous message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Thank you very much
Previous Topic: rep 1800 formatter error
Next Topic: complex calculation
Goto Forum:
  


Current Time: Sat Dec 03 11:54:55 CST 2016

Total time taken to generate the page: 0.10438 seconds