If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Parsing Error, cant see it.

Started by mbrassfi, 25 Jan 2010 03:15:19 PM

Previous topic - Next topic

mbrassfi

I have two fields, budget and actual, and the budget I want it to include only if Fund Type Level 1 = '30' and fund level 2 <> '300000', but for actual I want to include everything.  Here is what I wrote

IF ([Operating Ledger IIT].[Operating Ledger].[FUND_TYPE_LEVEL_1] = '30' AND [Operating Ledger IIT].[Operating Ledger].[FUND_LEVEL_2] <> '300000')
THEN (0)
ELSE ([Operating Ledger IIT].[Operating Ledger].[SUM_ACCUMULATED_BUDGET])

and I got this error

QE-DEF-0260 Parsing error before or near position: 229 of: "IF ([Operating Ledger IIT].[Operating Ledger].[FUND_TYPE_LEVEL_1] = '30' AND [Operating Ledger IIT].[Operating Ledger].[FUND_LEVEL_2] <> '300000')
THEN (0)
ELSE ([Operating Ledger IIT].[Operating Ledger].[SUM_ACCUMULATED_BUDGET]"
QE-DEF-0261 QFWP - Parsing text: IF ([Operating Ledger IIT].[Operating Ledger].[FUND_TYPE_LEVEL_1] = '30' AND [Operating Ledger IIT].[Operating Ledger].[FUND_LEVEL_2] <> '300000')
THEN (0)
ELSE ([Operating Ledger IIT].[Operating Ledger].[SUM_ACCUMULATED_BUDGET]

I placed this directly into the Query Data item for  [Operating Ledger IIT].[Operating Ledger].[SUM_ACCUMULATED_BUDGET]

Does anyone know what is wrong? Thanks!

mbrassfi

IF ([Operating Ledger IIT].[Operating Ledger].[FUND_TYPE_LEVEL_1] = '30' AND [Operating Ledger IIT].[Operating Ledger].[FUND_LEVEL_2] <> '300000')
THEN (0.00)
ELSE ([Operating Ledger IIT].[Operating Ledger].[SUM_ACCUMULATED_BUDGET])

MFGF

Hi,

Is the second post a fix, or is it something else you have tried which still doesn't work?

If it's the latter, my guess would be that it's unhappy with a data type somewhere - is FUND_TYPE_LEVEL_1 a text field or numeric?  What about FUND_LEVEL_2?

What data type is SUM_ACCUMULATED_BUDGET?

MF.
Meep!