Forum Discussion

Jorn_Mazet's avatar
Jorn_Mazet
Regular Visitor
2 years ago
Solved

Financial Statement - Measure issue

Hi all, I'm trying to create a measure to use in a matrix that uses other measures to show a financial structure: The measure used in the visual is "Amount per level" and each line in the m...
Need Help
  • Joe_Barry's avatar
    Joe_Barry
    2 years ago

    Hi Jorn

     

    It seems to be a relationship issue. When I remove the Relationship between FACT and DT_GL_Structure the Total Turnover without other works. This is how I have my P&L set up too. But there are issues with numbers for the lower hierachy.

     

    Unfortunately I don't hav etime to look into it more, but hopefully this will help you find a way.

     

    Thanks

    Joe

     

     

     

     

     

Jorn_Mazet's avatar
Jorn_Mazet
Regular Visitor
2 years ago

Hey Joe,
Thanks for taking the time to look at my post. 
The issue I'm having is not an issue of hierarchy for as far as I can see, it's an issue of a measure that doesn't show a result in my matrix (where standalone it does).
If you have insights in this specific issue, I'd love to hear from you!

  • Joe_Barry's avatar
    Joe_Barry
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Hi Jorn

     

    It seems to be a relationship issue. When I remove the Relationship between FACT and DT_GL_Structure the Total Turnover without other works. This is how I have my P&L set up too. But there are issues with numbers for the lower hierachy.

     

    Unfortunately I don't hav etime to look into it more, but hopefully this will help you find a way.

     

    Thanks

    Joe

     

     

     

     

     

    • Jorn_Mazet's avatar
      Jorn_Mazet
      Regular Visitor
      2 years ago

      Hey Joe,
      I would have never guessed that this relationship would be the issue!!
      Thanks!!
      PS: the lower hierarchy issue was just a simple sum to be added to the master measure 😉