Set Analysis Problem

[#1]

I have this expression:

sum( {$<Month = {$(=Only(Month)-1)}>} if(  Flag <> 'Fail' , 1, 0) )

But this way doesn't work, the result is always 0...

Someone know what's happen?

Thanks.

[sebastiandperei]

Hi,

With Only (Month), you need ALWAYS have a Month selected. Try with:

sum( {$<Month = {$(=Max(Month)-1)}>} if(  Flag <> 'Fail' , 1, 0) )

But for January Month this wont work, because the expression is not correctly made. Could you send a copy?

(hablás español?)

[whiteline]

What are your dimensions for this expression ? And what is the Flag ?