Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, my problem is:
I select a field PeriodEstimate with value Nov 2009.
I've a text with: MONTHNAME(PeriodEstimate-1) and the value is Oct 2009.
Then, I try to use it in a set analysis:
If I write:
=AVG({$< PeriodEstimate ={'Oct 2009'}>} [Result]) works fine.
But, If I write:
=AVG({$< PeriodEstimate ={'MONTHNAME(PeriodEstimate-1)'}>} [Result]) the result is null.
Can you help me? Thanks!!!
I think you need a dollar sign expansion for the Monthname expression:
=AVG({$< PeriodEstimate =
{'$(=MONTHNAME(PeriodEstimate-1))'}>} [Result])
I think you need a dollar sign expansion for the Monthname expression:
=AVG({$< PeriodEstimate =
{'$(=MONTHNAME(PeriodEstimate-1))'}>} [Result])
Thanks ninja NMiller!