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
Solution 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 😉