Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a table which is in State A:
Question | Note | Test | Cumulative 2016 |
---|---|---|---|
QA1 | 25.5% | 32.0% | 45% |
I have current selection of Month and Make for this state.
However, I want that the cummulative 2016 to bypass the state and cummulate the results of this current year.
I am using the expression below for the cummulative but the result is wrong:
=Sum({<Annee={">=$(=Max(Annee))"},QA1={'<>NSP'}>}QA1)/Count({<Annee={">=$(=Max(Annee))"},QA1={'<>NSP'}>}QA1)
Any idea?
Many Thanks,
Hasvine
May be this:
=Sum({<Annee={">=$(=Max(Annee))"},QA1={'<>NSP'}, State>}QA1)/Count({<Annee={">=$(=Max(Annee))"},QA1={'<>NSP'}, State>}QA1)
If this doesn't work, would you be able to provide a sample?