Specific value sum in field

[rassanbekov]

Hello! Please help resolve the issue

I need to sum up the specific value in field.

For example, I need to find amount of "empty boxes" (Header 3) by summing up Header 2.

Header 1	Header 2	Header 3
A	10	Apple
B	10
C	20	Pine
D	40

Kind regards,

Ruslan

[daveamz]

Hi Ruslan,

Have a look at the attached file.

Regards,

David

[Anil_Babu_Samineni · Accepted solution]

You can do this number of ways. one way is simple

Sum({<[Header 3] = {''}>}[Header 2])