Hi, I’m trying to find a way to work around the countif formula. I have two different transaction types. I’d like to create a formula that counts number of Transaction Type A records and another formula that sums the revenue from Transaction Type A records.If anyone has a workaround/solution I would very much appreciate the guidance.
Hi @Karen_Larson - how about this:
Make the types its own table and in the transactions table, link to the type:
Back in the Types table you can rollup and count the transactions by type: