Correct Answer and Response not giving same values

[mahdulhaq]

I have two columns CORR_ANS(Correct Answer) and RESPN(Response) both have values YES and NO, if correct answer and respnse are equal then i want the graph to go upwards and if the correct answer and response does not match then i want the line graph to go down

I am using the condition if( CORR_ANS = CAPS, count(distinct Q_ID) , -count( distinct Q_ID) )

[BrunPierre]

If( LTrim(UPPER(CORR_ANS))=LTrim(UPPER(RESPN)) CAPS, Count(DISTINCT Q_ID) , -Count( DISTINCT Q_ID) )

[mahdulhaq]

I tried this method but it didn't give me desired answer, i want " if the caps and correct answer doesn't match the graph will show zero and if they match they will give count how many gave correct answer"

[BrunPierre]

Post some data sample & desired output.

[mahdulhaq]

[mahdulhaq]

kindly see these 3 pictures and also check there selections and their months.