Forum Discussion

pawlowski6132's avatar
pawlowski6132
Icon for Helper V rankHelper V
5 years ago

MTD and Matrix Not Behaving as Expected

I'm including two errors as they may be related.

 

I have measures that work on a daily basis. 

 

For example, on 1/3/21, the Total Expense if work a shift is $6,945. We worked 0 shifts so the Planned Total Expense was $0.

on 1/4/21 the planned Total Expense is $7,250, we worked three shifts so the Planned Total Expense was $21,749.

 

Now 1) The MTD is all hosed up, where are those numbers coming from? 2) the Total of the Total Expense per Day colum,n is $25,685. What is that supposed to be? The total SHAP MTD Planned Total expense is 63x25,685 but why?

 

I don't even know where to start. Any suggestions on what could be causing these issues. I've spent over 1/2 day trying to understand this. Ugghh. 

 

Thanx in advance.

 

 

 

 

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    5 years ago

    pawlowski6132 you have given the partial information, paste the data in a table format (or excel file), and share what is your expected result. It is not clear from your post what kind of MTD calculation you are doing. Share file thru one drive/google drive.