AshleyHarris
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Counting records with the same Concatenated Values
Hey Mike, No, I need to count the # of Transactions based on the Concatenated Field that I have created. Records where the value in the Concatenated Field are the same, I only want to count once. Does that make sense? ------------------------------ Ashley Harris ------------------------------Re: Counting records with the same Concatenated Values
Hey Simon, My Concatenation field is what identifies the 2 records that should be counted as 1. Its the ID that is the same between the 2. I tried counting with the Distinct Count function on the summary field while summarizing on my Concatenated field, and it's still counting each record individually. In my example below there are 10 Transactions but when Combined via the Concatenated field there should only be 6 Transactions. ------------------------------ Ashley Harris ------------------------------Re: Override a date formula field?
Hey Julie, Try creating a regular Date field and another Formula Date field. Make the Date field your "manual" entry. Personally, I like to include "Manual" in the field name. In the 2nd Formula Date field, use the formula below. Nz([Call Date (Manual)],[Call Date +14]) ------------------------------ Ashley Harris ------------------------------Counting records with the same Concatenated Values
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 ------------------------------Formula Checkbox based on Text-Multiple Choice
I need help with a formula for a Formula - Checkbox field. When the value in a Text-Multiple Choice is Yes then Check the Box. This is where I am currently at. I'm getting an error on the "Yes". IF(Contains(ToText([Registered Agent for any Entity]),Yes) = true) ------------------------------ Ashley Solomon ------------------------------
