Forum Discussion

lilySixteen's avatar
lilySixteen
Helper III
6 years ago
Solved

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...
  • amitchandak's avatar
    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