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!
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])
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.