sql condition in expression(urgent plsssss...)

[#1]

Hi experts,

I have used the following expression for counting the no. of invoices (MTD) in a pivot table

Expression = count({<CalendarDate=, CalendarMonthYear= {">=$(=date(MonthStart(Max(CalendarDate))))<=$(=date(Max(CalendarDate)))"}>} InvoiceNo)

I have to include the following sql condition in the above expression.

sql condition  = COUNT(DISTINCT CASE WHEN ORDTYPE='SL' THEN ISNULL(InvoiceNo,'') END)

How can i include this.

please help

[Gysbert_Wassenaar · Accepted solution]

Try:

count({<ORDTYPE={'SL',} CalendarDate=, CalendarMonthYear= {">=$(=date(MonthStart(Max(CalendarDate))))<=$(=date(Max(CalendarDate)))"}>} if(IsNull(InvoiceNo),'',InvoiceNo))

[#3]

Thanks a lot