Counting Records

[Nikhil86]

Hi All, 

I am trying to count the number of records and populate it in of the fields. I don't want to use summarize tool to do this for various reasons: I am trying to get my head around formula tool . Has any one used formula tool to count the records in the spread sheet? 

Basically the expression should return the no of records present in the spreadsheet. If the count is 10 the Test_Count should return 10

[atcodedog05 · Accepted solution]

Hi 

There is no formula for it. But you can use count record to get row count and append that column to the main data.

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂 @Nikhil86 

Cheers and Happy Analyzing 😀