Forum Discussion
Solved
Calculate percentage between two columns
Hi, As a new user I assume it's possible to have a column with the percentage or remaining seats in a room. I have several information sessions and zo far I can see the currentlyBooked & remainingS...
As a calculated column in SlotsCapacity table you can use:
Percentage =
DIVIDE(
[Remaining Space],
[Max Capacity],
0
)As a measure
Percentage =
DIVIDE(
SUM(SlotsCapacity[Remaining Space]),
SUM(SlotsCapacity[Max Capacity],
0
)
Hope this helps.
Thanks jgeddes,
It's working fine for me