How to subtract from one count to another count

[saivina2920]

I'm using count in two different text boxes. Finally i want to subtract from one count to another.

For example

Textbox1 = Count({<[TO]={'EMP-DESIGN'},[FROM]={"$(vplace)"}>} DISTINCT [EMP_NUM])

Textbox2 = Count({<[FROM]={'EMP-DEISGN'},[TO]={"$(vplace)"}>} DISTINCT [EMP_NUM])

I want in textbox3 = sum(Textbox1 - Textbox2) ==> Otuput....

How to do this...?????

[Sergey_Shuklin]

Hello!
There is no refference to the objects in QV. You'll have to use the same expression as you used in Textbox1 and Textbox2.
So in Textbox3 you should place:
sum(Count({<[TO]={'EMP-DESIGN'},[FROM]={"$(vplace)"}>} DISTINCT [EMP_NUM]) - Count({<[FROM]={'EMP-DEISGN'},[TO]={"$(vplace)"}>} DISTINCT [EMP_NUM]))

[saivina2920]

But, It shows Expression OK. but, it's showing error.

pls. find the screenshot..

[sunny_talwar · Accepted solution]

How about this

Count({<[TO]={'EMP-DESIGN'},[FROM]={"$(vplace)"}>} DISTINCT [EMP_NUM])
-
Count({<[FROM]={'EMP-DEISGN'},[TO]={"$(vplace)"}>} DISTINCT [EMP_NUM])

[saivina2920 · Accepted solution]

no..it's showing as string entire code...
I want to use this in Textbox expression
anything shall i use
equals before count like,
=count (....) - count(...)

[sunny_talwar]

Yes, you do need the equal, my bad for forgetting it....

[saivina2920]

done..thanks...

[sunny_talwar]

no problem, I am glad you were able to figure it out 🙂