Forum Discussion

KH11NDR's avatar
KH11NDR
Icon for Helper IV rankHelper IV
8 years ago
Solved

Subtracting two measures in a matrix table and getting the wrong answers

Hi Guys,   When I try this measure below, my results are nowhere near the number I'm looking for. I know it's going to be hard to solve this one with the details given., The tables a matrix and I a...
Need Help
  • KH11NDR's avatar
    KH11NDR
    8 years ago

    I've sorted it, bit of advice, if your calculations are well off, check the formats of your numbers, one was one decimal place out hence made a huge differnce.  It was general data type in Excel, changed it to Number and made sure all my numbers in the columns and measures were all the same format and boooom the correct answer.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello everyone.
I have some problem like this post.
However I can't solved.

 

Here the table

 

Here the fields

It's possible to do it?

 

tks everyone

 

KH11NDR 

 

hanny's avatar
hanny
Frequent Visitor
3 years ago

Have you solved this? I got the same problem.