1 Reply Latest reply on Jan 23, 2018 6:11 PM by Shinichiro Murakami

    Transaction Count as a % of Exchange Price

    Maxwell Gray

      Hey guys - I want to create a calculation that gives me a count of transactions/a given exchange price by day for a stock. Have the data - just getting an error saying I cant mix aggregate and non-aggregate with this function. Here is what I tried:

       

      count(transactions)/[exchange price]

       

      Any help would be greatly appreciated.