Hi,
My requirement is to display output as yes or No, for the 2 columns which has values 0 or 1.
So I have used below expression to get this, but getting
QE-DEF-0459 CCLException and QE-DEF-0260 Parsing error before or near position error in cognos report studio 10.2.
if ([Audit].[Audit Detail].[Audit Detail].[Audit Detail].[Question Is Auto Failure] and
[Audit].[Audit Detail].[Audit Detail].[Audit Detail].[Answer is Auto Failure] = 1)
then 'Yes'
else
'No'
end
Can any one help me to solve this ASAP?
Thanks
Gopi
Unless your first condition is on a boolean data type, the expression is not valid. From what you wrote, you need to compare it to 0 or 1.
Looks like you've got quite a few errors in there:
Quoteif ([Audit].[Audit Detail].[Audit Detail].[Audit Detail].[Question Is Auto Failure] and
[Audit].[Audit Detail].[Audit Detail].[Audit Detail].[Answer is Auto Failure] = 1)
then 'Yes'
else
'No'
end
I think it ought to read something like:
Quoteif ([Audit].[Audit Detail].[Audit Detail].[Audit Detail].[Question Is Auto Failure] =1 and
[Audit].[Audit Detail].[Audit Detail].[Audit Detail].[Answer is Auto Failure] = 1)
then ('Yes') else ('No')
Hi,
I need to display as 'Yes' in the report, if my 1st condition is true ([Audit].[Audit Detail].[Audit Detail].[Audit Detail].[Question Is Auto Failure] and [Audit].[Audit Detail].[Audit Detail].[Audit Detail].[Answer is Auto Failure] = 1)
Else
it should display as 'No' .
Logic here is that : if Question is auto failure and answer is auto failure is 1, then it is auto failed (yes), else it is not.
So I am using above logic...I hope it clears now.
Did my suggested version work for you?
yes, when i gave this condition and ran the report am getting wrong data, so need to re- design the model and report to get the issue fixed.
I am using dimensional modelling in my project. When I run the report few columns am getting same data ...so which is not correct.