Divide by zero on Table transformer

emagnun

Hi I'm trying to calculate growth over year. As you can see below yellow highlighted, product B has "zero divide by number" case and growth is shown as "infinity". How to get this shown as 100%. ?? 

My Table transformer Query is as below.

============================
SELECT *,
ROUND(((T1.'Count FY2020' - T1.'Count FY2019')/T1.'Count FY2019')*100, 2) AS 'Growth, %'
FROM T1

============================

Katerina Kovriga {Stiltsoft}

Hi @emagnun ,

Please try the following:

SELECT T1.'Product Type', T1.'Count FY2019', T1.'Count FY2020',
CASE
WHEN ROUND((T1.'Count FY2020'*100/T1.'Count FY2019' - 100), 2) LIKE "Infinity"
THEN "100"
ELSE ROUND((T1.'Count FY2020'*100/T1.'Count FY2019' - 100), 2)
END
AS 'Growth, %'
FROM T*