Function within a set analysis expression

[#1]

Hi,

I want to be able to print total number of IDs my table for the latest month.

To retrieve the latest month I use MaxString([CreationDate]) which gives me the correct month in format '2012-03'.

When I try to use it in my set analysis expression it does not work, it comes out null:

(This is put in a texbox)

=count( {$<CreationDate = {$(=MaxString(CreationDate))} >} [E_ID]);

I can use the following expression and it works:

=count( {$<CreationDate = {'2012-03'} >} [E_ID]);

I'm pretty sure I just dont know the syntax...

Regards

Mikael

[rajni_batra · Accepted solution]

=count( {$<CreationDate = {"$(=MaxString(CreationDate))"} >} [E_ID]);

or u can store maxstring(date) in a variable and use that variable, that can also help u

[#3]

Thank you!