Set Expression?

[prajapatiamar38]

Hi Community,

I have one expression I want to write that in set analysis How can I..

Count(Distinct if(Year([Prev Date])=Year([Jobcard Date]) and Month([Prev Date])=Month([Jobcard Date]),[Jc No1]))

Pls Help

Thanks

[MK_QSL]

May be below... Haven't tested...

=Count(

     {<

          [Prev Date] = {"=

                                        Year([Prev Date])=Year([Jobcard Date])

                                        and

                                        Month([Prev Date])=Month([Jobcard Date])"},

        >}

[Jc No1])