Help with Date Expression Set Analysis

[antoniodneto]

Hi Guys!,

I have a number field called DATA_BASE_FINAL on format YYYYMM.

I'm using a expression for my dimension =date(date#(Max(DATA_BASE_FINAL),'YYYYMM'),'MMM/YY') and returns me the date Oct/18 correctly.

But I'm trying to put it on my set analysis this way  =SUM({<DATA_BASE_FINAL={"$(=date(date#(Max(DATA_BASE_FINAL),'YYYYMM'),'MMM/YY'))"}>}SDB_ATUAL)/1000000 and does not work.

Have a problem with my expression?

Tks all!!

[swuehl]

Seems like you are trying to filter a value in the format MMM/YY, but as you said, the field values are formatted in YYYYMM. Why do you reformat?

Try

=SUM({<DATA_BASE_FINAL={"$(=Maxstring(DATA_BASE_FINAL))"}>}SDB_ATUAL)/1000000