Set Analysis Syntax

[#1]

I have a pie chart that is supposed to break down Passing, Failing and Excluded for the most recent report End Date.

I am using the expression:

count({<P219A_STATUS_C={1},[END DATE]={"=$(Max([END DATE]))"}>}P219A_STATUS_C)

P219A_Status_C:

     1= Passing

     2= Failing

     3= Excluded

The Max(End Date) = 10/28/2013

When I use count({<P219A_STATUS_C={1}>}P219A_STATUS_C)  and select the end date from a list box my results show 63 passing but when I try to include max(Date) in the set analysis my result shows passing as 0

Any ideas on my syntax error?

Thanks

[swuehl]

What is your standard date format? Or, if you put this in the text box:

=date(41579)

What exactely do you get? Compare this to the max date in the END DATE list box. Even a difference like 11/1/2013 vs 11/01/2013 does matter here.

[#3]

ahh ha... it is different

=date(41579) .... 11/1/2013

Max End Date is 11/01/2013

So then would I have to use...

({1<P219B_STATUS_C={1},[END DATE]={"$(=Date(Max({1}[END DATE])),'MM/DD/YYYY')"},MU_EP_Flag={'Y'}>}P219B_STATUS_C)

That doesn't seem to be working...

Thank you SOOOOOO much for your help.  I am going to try to attach a file to my original question to see if anyone has time to take a look!

[swuehl]

That would explain your issue, though.

In above expression, I think you have one closing bracket too much after [END DATE].

If this is your real expression and not a copy&paste issue, try correcting the field modifier.

[#5]

good catch but same results!