Set Analysis for substraction

[Anonymous]

Hi All,

As shown in below image, I need Coding Review count = Coding Review - Coding Count

Business logic is , If i am doing coding review for company, Process Doc Type then all documents coded by me will be reviewed by me.

And these should not be considered in my review count.

Attaching the sample Excel and QV file

Thanks

[sunny_talwar · Accepted solution]

May be this

=If(ProcessType = 'Coding Review', Sum(NoOfTrans) - Sum(TOTAL <CompanyName, Processor, ProcessDocType>{<ProcessType = {'Coding'}>} NoOfTrans), SUM(NoOfTrans))

[Anil_Babu_Samineni]

Can you make Result set in new column please

[Anonymous]

Hi Sunny,

It worked perfect . Thanks for the solution