Count lines higher than other lines

[#1]

Hello everyone,

I need your help about a set analysis expression.

I have to count the number of Lines higher than Invoice AND whose Invoice is not equal to 0.

To do that, I did this expression :

=Count({<Lines={"=Lines>Invoice"}*{"=Invoice<>0"}>}[Lines])

But the result does not seem very correct..

Do you have any idea to improve the expression ?

Thanks

[#2]

=Count({<Lines={">=Invoice"}, Invoice={">=0"}>} Lines)

[#3]

try this

=count(If((lines>invoice and invoice<>0),lines))

[#4]

try:

Count({<Lines = p({<Lines = {'>=$(=Invoice)'}>}Lines)*p({<Invoice = {'>=$(=0)'}>}Lines) >}Lines

[its_anandrjs]

Some change

=Count({<Lines={ ' >Invoice ' }, Invoice = {">0"}>} Lines)

[tresesco · Accepted solution]

This sort of set analysis gives right result only if the comparison field (here Lines) has unique values (i.e - a key field). Otherwise, try using if like: =Count( If(Lines>Invoice and Invoice<>0 ,[Lines]) )

[#7]

Thank you everyone for your response !