tell me the below requirement how to do?

[gkcchowdary]

Hi,

I have fields     

ID	sourcecount	targetcount	errorcount
11	27	24	3
12	10	5	5
23	15	23	0
34	100	100	0
22	200	200	0
45	300	100	0

the above table id 11 sourcecount 27 and targetcount 24 and error count is 3.this is fine because of sourcecount =targetcount+errorcount(27=24+3)in this 27 =27.

my requirement is i want show the only which BachID  sourcount not equal to tatgetcount+errorcount.that means id 23 and 45. this only sample data my original data having more fields and more columns. so how to write the expression sourcecount -= targetcount+error count in set analysis.

Thanks

chaitu

[jcampbell474]

Don't know if you need set analysis, but maybe try this expression:

=IF(targetcount+errorcount <> sourcecount,ID)

[sunny_talwar]

May be this set analysis in your expression

{<ID = {"=sourcount <> RangeSum(tatgetcount, errorcount)"}>}

[qv_testing]

PFA,