Forum Discussion
lennox25
Post Patron
Post PatronHOW TO COUNT ALL ROWS IN A TABLE INCLUDING DUPLICATES (STORES) AND DIVIDE BY 7
Can anyone help? I need to count all rows in a table including duplicates and divide that by 7?
Hi lennox25
You can count all rows in a table by using the function COUNTROWS(Your_table).
To divide that by 7 you will update the code as below= DIVIDE (COUNTROWS(Your_table), 7)
Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge
2 Replies
- DataVitalizer
Super User
Hi lennox25
You can count all rows in a table by using the function COUNTROWS(Your_table).
To divide that by 7 you will update the code as below= DIVIDE (COUNTROWS(Your_table), 7)
Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge
lennox25Worked perfectly - Thank you!