A nicer way of doing this is to use NULLIF like this:
[code type=sql]Percentage = 100 * ClubTotal / NULLIF(AttTotal, 0)
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/nullif-transact-sql
A nicer way of doing this is to use NULLIF like this:
[code type=sql]Percentage = 100 * ClubTotal / NULLIF(AttTotal, 0)
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/nullif-transact-sql