Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?)
What are your dimensions for this expression ? And what is the Flag ?