If statement and count not working

[que1983]

if([Presentation Layer].[CORRESPONDENT PENDS].[Pend Description] not like 'XINTR%' then
count([Presentation Layer].[PIPELINE POST FINAL ACTION].[Loan Number])

I am getting this error failed to load report specification query not allowed in query service.  I want to do a count only if the above description is not like XINTR

[BigChris]

You could try an alternative approach is that isn't working:

total( if([Presentation Layer].[CORRESPONDENT PENDS].[Pend Description] starts with 'XINTR') then (0) else (1))

[MFGF]

if([Presentation Layer].[CORRESPONDENT PENDS].[Pend Description] not like 'XINTR%' then
count([Presentation Layer].[PIPELINE POST FINAL ACTION].[Loan Number])

I am getting this error failed to load report specification query not allowed in query service.  I want to do a count only if the above description is not like XINTR

You appear to be missing some parentheses and an else clause in this expression. Have you tried:

if([Presentation Layer].[CORRESPONDENT PENDS].[Pend Description] not like 'XINTR%') then
(count([Presentation Layer].[PIPELINE POST FINAL ACTION].[Loan Number])) else (null)

MF.