Forum Discussion

BPTBPTBPT's avatar
BPTBPTBPT
Icon for Helper II rankHelper II
4 years ago
Solved

From table to one digit

How can I get a table to just one digit? 

 

I this case I need 

 

.. to become 13 (which is the amount of rows with "send" in the column "status"). So all other data may be gone. How do I do that?

Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    Filter on that column with send and then click on countrows button on the ribbon

3 Replies

  • SpartaBI's avatar
    SpartaBI
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Filter on that column with send and then click on countrows button on the ribbon

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

    That actually worked!

    Thanks! 

    There is a new problem, though, for some reason it wants to convert to a table. I dont need a table, just want the "13". What to do?

     

     

     

     

    • SpartaBI's avatar
      SpartaBI
      Icon for Community Champion rankCommunity Champion
      4 years ago

      You can disable the load and it will allow you to keep it as just a number