convert if to set analysis

[#1]

Hi Experts,

Can somenone pls help me writing below code in set analysis?

=count(if((Reported_Out_All.count_id =' ' And

            not Isnull(Reported_Out_All.Bill_Type_Details) and

            (QuarterName(Reported_Out_All.Reported_Out_Date) = QuarterName(max_Reported_Out_Date_All))),

                                Reported_Out_All.Reported_Out_case_id) )

Thanks,

Rohini. M

[rospigliosi]

Hi Rohini,

try this one:

=count({<

        Reported_Out_All.count_id ={" "},

        Reported_Out_All.Bill_Type_Details={"*"},

        QuarterName(Reported_Out_All.Reported_Out_Date) = {"$(=QuarterName(max_Reported_Out_Date_All))"}

        >}

        Reported_Out_All.Reported_Out_case_id)

[#3]

Hi Camillo,

Thank you for your reply. But its showing error at

QuarterName(Reported_Out_All.Reported_Out_Date) = {"$(=QuarterName(max_Reported_Out_Date_All))"}

this part of expression. So cant we give dynamic value as set modifier?

Can you pls help fixing this.

Thanks,

Rohini. M