Skip to main content
Question

Counting records with the same Concatenated Values

  • May 1, 2023
  • 0 replies
  • 143 views

I have a Transaction Table that breaks out some payment into 2 records (Principle & Interest). 

In another table (parent), I need to count those 2 records as 1 Transaction when I am summarizing up so that I have a correct calculation for # of Transaction over a period of time. 

I created a Concatenation (formula field), and have tried Summarizing but I can only use the Combined Text function. I need the Count function. 



What is the best way to count records where the value in the Concatenate field is the same, so I can Summarize up to the Parent with a number value?

Thanks in advance for the help. Ashley



------------------------------
Ashley Harris
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+5
    • SimonH
    • Registered
    • May 1, 2023

    When a payment is split in 2 do they each have some sort of ID number that is the same?
    If so you can use the summary type "Distinct Count" on that field to get your number of transactions.



    ------------------------------
    Simon H
    ------------------------------
    Terms & ConditionsAccessibility statement