Forum Discussion
Solved
Count Rows in Multiple Related table - Calculated column
Hello, I am attempting to count the total number of rows in a series of related tables. How would I go about creating a calculated column that would calculate the total number of rows in each related table.
E.G. I would like to know how many rows is in each ORDER_DETAILS table.
You can directly add a custom column using Table.RowCount() function to get the row count of each table.
Regards,
2 Replies
You can directly add a custom column using Table.RowCount() function to get the row count of each table.
Regards,
You would probably have to do a count on them separately and then merge them back with the table you wanting to store the information in.
