HOW TO COUNT ALL ROWS IN A TABLE INCLUDING DUPLICATES (STORES) AND DIVIDE BY 7

[lennox25]

Can anyone help? I need to count all rows in a table including duplicates and divide that by 7?

[DataVitalizer · Accepted solution]

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

[lennox25]

Worked perfectly  - Thank you!