Forum Discussion
Matrix not calculating line items correctly.
Hi all. I see so many issues with the matrix incorrectly calculating values, now it's my turn to add my problem to the group.
when i calculate month to month % it works fine.
But when I attempt to calculate by Quarter over Quarter or Year over Year, incorrect Results.
My example below illustrates this.
For example, here is the matrix of one record
390/39 of course is not = to 1009.40
Switching it from matrix to table doesn't change the %
How do i resolve this so that the % are correctly calculating? Any ideas?
Always appreciate help.
Thanks, Steven Taub.
So it looks like the error is some how occuring before the data is actually posted into the visual. Rounding errors maybe?
Do you have any suggestions for me on resolving this?
Thanks...
Hey StevenT ,
how do your measures look like?
How is the data model?
What result do you expect?
Can you provide a sample file?
If you want someone to help you, then add more details. Nobody knows why the result is like that if you don't tell which calculation you are using.
Best regards
Denis
3 Replies
Hey StevenT ,
how do your measures look like?
How is the data model?
What result do you expect?
Can you provide a sample file?
If you want someone to help you, then add more details. Nobody knows why the result is like that if you don't tell which calculation you are using.
Best regards
Denis
StevenT Please provide some data. So that we can try from our end.
Actually, I was able to complete this task and I figured out what i was doing wrong.
I was incorrectly identifying a measure that wasn't matching the Month Quarter and Year and I resolved it.
Thanks!
