Forum Discussion

Lowe182's avatar
Lowe182
Regular Visitor
4 years ago

Total row not calculating correctly - Matrix Measure

Hello all,   I have tried other solutions to my problem but none of them worked for me. I have a matrix that projects annual expenses by pay period. For now, the "Projection" column fills in any mi...
Need Help
Lowe182's avatar
Lowe182
Regular Visitor
4 years ago

Thank you for the proposed solution, unfortunately I'm still stuck on the getting the total to sum as intended:

 

 

My guess is this could be related to PR26 - FY2022 missing from the dataset completely, as this payroll has not been posted yet. 

 

Thank you

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi Lowe182 

    Thanks for your reply.

    In general, the correct total row can be obtained by creating 3 measures like this.

    If you want to continue troubleshooting, could you share a sample file? you can use bogus data to replace raw data.

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.