Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

GL Entry - Totaling GL Accounts

Hi all,

 

I have an issue when trying to calculate a total between a range of accounts (Total sales, Sum accounts between 1001-1900 etc).

 

I have created below measure:

 

GL amount = SUMX(Kontoplan;
IF( NOT ISBLANK(Kontoplan[Totaling.2]);
CALCULATE ( SUM(Finansposter[Realized, Amount]);
FILTER(ALL(Kontoplan); Kontoplan[No_] > EARLIER(Kontoplan[Totaling.1]) && Kontoplan[No_] < EARLIER(Kontoplan[Totaling.2])) );
CALCULATE ( SUM(Finansposter[Realized, Amount]) ))
)

 

The amounts are korrect for each individual account, but it is not correct on the Total accounts, which is a Sum between the range in Totaling 1 and Totaling 2. I guess it also calculates the Sub Total accounts, when calculating the Total.

 

Can anyone assist here?

 

Need Help

2 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

    I have tested the data you post in the problem and I could get the correct sum like the picture below. I could not find the sub total data you mentioned in your problem, could you please offer more information about the structure of your data or could you share pbix file if possible? If the report does contain sensitive data, please upload your report to your OneDrive and send the link to me via private message.

    Regards,

    Daniel He

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Daniel,

       

      Appreciate your time and respond, I will make a demo file tonight/tomorrow and send it to you - thanks!