Forum Discussion

feralvarez994's avatar
feralvarez994
Icon for Helper II rankHelper II
4 years ago

Show correct total amount

Hi everyone! 

 

I have 2 issues with my table:

First one - I need to have the totals of VAR SALDO CC but i cannot make it visible, i dont know why. I am sure theres something wrong with my SUMX and SUMMARIZE used in the VAR SALDO CC measure

Second one - I would like to make subtotals of the positive VAR SALDO CC and negative VAR SALDO CC, adding each one and showing the positive and negative subtotal, can that be possible?

Both issues need to be shown in the table that is in the bottom part from the second page.

I am attaching the link with the PBI FILE im working, hope someone can give a hand!

 

PBI FILE

3 Replies

    • feralvarez994's avatar
      feralvarez994
      Icon for Helper II rankHelper II
      4 years ago

      tamerj1 Hi again! Thanks a lot for the quick answer. There's still something wrong with the totals. The total amount of VAR SALDO CC has to be the SALDO CC from the upper table. I dont know if i have done something wrong calculating the VAR SALDO CC. Also when i dont press any filter, the total amount is too big, i think because it calculates over all the rows in CTACTE, i only need to take in consideration the clients that are in SJ TRANSF table

       

      About the second questions, i was trying to do something like this (if possible, if not theres no problem at all) just to make it clearer

       

       

       

      Thanks again for everything that you do, and sorry if i cant explain myself as good as i want, english is not my main language haha