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

     

     

     

     

     

AmiraBedh's avatar
AmiraBedh
Super User
2 years ago

I found it because simply the GL_account is empty or NULL in the DT_GL_Reporting Structure table for Level1 =

TOTAL Turnover without other



 

Jorn_Mazet's avatar
Jorn_Mazet
Regular Visitor
2 years ago

The GL_account is empty because line for the line "TOTAL Turnover without other" is suppose to be calculated by adding 2 other measures instead of summing GL accounts; that is the premise of the question...