SET ANALYSIS - COUNTIF

[Anonymous]

Hi ,

Please assist with the syntax for the set analysis.

I want to do a count if DATE1>DATE2 and COUNT the number field.

Thus,

=Count({DATE1>=DATE2}[NUMBER])

Thanks in advance.

[Anil_Babu_Samineni]

=count({$<DATE1 = {">DATE2"}>}number)

[#3]

Hi,

Set analysis could be used for filtering the records, it can be used to filter the records for certain range of dates it could not compare. you can use simple if function .

[tyagishaila]

Hope it will work,

Count({<Date1 = {">=$(Date1)"}>}Number)

[tresesco]

Try like:

=Count({<DATE1={"=DATE1>=DATE2"}>}[NUMBER])

Make sure that DATE1 and DATE2 have similar date formats.

[muthukumar77]

Hi,

Refer this App.