Formula = count({$<#field1='{''}>} * ({$<field2={1}>} field 3)

[#1]

Dear all,

we want to count all data of field 3 where we have an intersection from 2 fields both with a constraint.

This formula does not work:

=count({$<#field1='{''}>} * ({$<field2={1}>} field 3)

Hope someone could help us

Best regards

Armin

[ariel_klien · Accepted solution]

Hi

Try

=count({$<field1={''},field2={1}>} field3)

BR

Ariel

[er_mohit]

try this

=count({$<#field1='{''}>* <field2={1}>} field 3)

[#4]

Dear all,

thanks both versions work.

Armin

[#5]

Dear all,

thanks both versions work.

Armin