1 Reply Latest reply on Mar 10, 2017 2:26 PM by Deepak Rai

    Trying to subtract total rows from displayed rows of Joined DB's

    evin hernandez

      Hello All ,


      Im having a huge problem with trying to do simple subtraction from my Total rows (not displayed in the window ) vs whats displayed in my window.


      number of machines
      12345version 2 a 231
      4235version 3c272
      5322version 588209


      I want to display in the next column 110 total rows - id and i will get the sum 110- 23 =


      I have tried count(id) - total(count(id))) but i get an error that it cannot blend / aggregate the data


      any help would be appreciated . I cannot attach a work book because it is sensitive information.