Forum Discussion
lilySixteen
6 years agoHelper III
rate calculation formula
Hello, I have a tenant table to show tenant data for every shopping center. Every shopping center has a # of units that can be rented to tenants. In the "tenant name" column it contains value "Va...
- 6 years ago
lilySixteen , Something like this
divide(calculate(countrows(Table), filter(Table,Table[tenant name]="Vacant")),countrows(Table))No need multiple by 100, Mark as % column
amitchandak
6 years agoSuper User
lilySixteen , Something like this
divide(calculate(countrows(Table), filter(Table,Table[tenant name]="Vacant")),countrows(Table))
No need multiple by 100, Mark as % column
lilySixteen
6 years agoHelper III
amitchandak Thanks so much! It worked.