Forum Discussion
Matrix totals wrong . . PLEASE HELP
I am going agg trying to figure this out and am running out of time to hit deadline.
I have a matrix that has 3 measures as shown below:
My totals are obviously not correct. What am I doing wrong?
Rev | a/p % = DIVIDE([Total Rev],[Rev | plan])
Rev | a/p $ = if(isblank([Rev | a/p %]),0,[Total Rev]-[Rev | plan])
Rev |fc/p% = DIVIDE([Rev | fc],[Rev | plan])
1 Reply
You would need to think about what you "want" to happen. Realize the totals are nothing more/less than evaluating your measures WITHOUT a filter on Fiscal Quarter. It's not like it is somehow using the rows above it to build a sum or average or whatever.
36.05% is "correct" in that it is [Total Rev] / [Rev | Plan] ... completely ignoring Fiscal Quarter. (You probably have a PLAN for Q2, but not Revenue yet... so the % looks small).
