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.

       

      build
      Version
      id
      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.