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 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))
Quote from: que1983 on 17 Mar 2016 02:21:53 PM
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.