Hello, I have a beast mode that calculates a % and I need it to round to 2 decimals.
I'm using the round function as described in the documentation:
CONCAT(ROUND(1-(COUNT(DISTINCT `nc_list`) / COUNT(DISTINCT `lot_number`)),2)*100, '%')
However, the result is being rounded to the whole number
I need it to, using the example above, display 97.91 instead of 98
What am I missing in my beast mode?