Total minus selected count

[qv_bazz_10]

Hi guys,

I'm trying to add an object to count total minus selected values you can see highlighted in yellow in the "Current Selection" object for the field "Siti.COD_STRUMENTO_PDR":

As you can see, the total is 158999 and 158967 is the total of selected values, so the number i'd like to have in the new object is 32 (with or without the two totals, even the simple result of the substraction is perfect):

158999 -

158967 =

        32

Can anybody help me? N.B. I can't work on the scritp and i can't upload the file because i'm using a shared document.

Thanks in advance,

Andrea

[sunny_talwar]

May be like this in a text box object

Count({1} Siti.COD_STRUMENTO_PDR) - Count(Siti.COD_STRUMENTO_PDR)

[Anil_Babu_Samineni]

Try this

Sum(total field) - sum({1<field = {$(=getfieldvalues(field))}>}field)

[qv_bazz_10 · Accepted solution]

@ Sunny and Anil: i tried both your expressions but i didn't get the result i was searching for. Anyway, triyng them, I found the solution with the function "GetExcludedCount":

=GetExcludedCount (Siti.COD_STRUMENTO_PDR)

Thanks a lot for your help!

Andrea