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

nvprasad's avatar
nvprasad
Solution Sage
6 years ago

Hi,

 

Try below formula

 

Vacancyrate =
DIVIDE (
CALCULATE ( COUNTROWS ( tablename ), tablename[tenant name] = "Vacant" ) * 100,
COUNTROWS ( ALL ( tablename ) ),
0
)

 

Thank You,

Venkata Nalla

lilySixteen's avatar
lilySixteen
Helper III
6 years ago

nvprasad Thank you for helping me. Your answer is correct when calculating the total but not when calculate by shopping center. Thanks again for providing your answer!