Custom Column of SUM columns

Using MariaDB :
TableA
Name | ColA | ColB |
dogs | 1 | 2 |
dogs | 3 | 20 |
cats | 10 | 20 |
cats | 30 | 40 |

Now id I do a summerize. SUM(ColA) , SUM(ColB) GROUP BY NAME ORDER BY Name
This would look like
Name | Sum of Col A | Sum of Col B |
dogs | 4 | 22 |
cats | 40 | 60 |
This works perfectly
Now I want to add another custom column to get the pct of ColB to ColA
So when I go through the GUI to create a custom column I put :
[Sum of Col B] * 100 / [Sum of Col B]
When I try and Visualize I get the error : Unknown column ‘source.Col B’ in ‘field list’
When I look at the SQL it has source.sum or source.sum_2
If I don’t add the custom column then the sql has the table name and column names as they exist in the DB.
What am I doing wrong or is something wrong with Metabase?
MAC OS : 10.15.6
MetaBase : 0.36.4
DB : mysql Ver 15.1 Distrib 10.4.12-MariaDB, for Linux (x86_64) using readline 5.1

Hi @bpatton
You’re seeing this issue:
https://github.com/metabase/metabase/issues/12762 - upvote by clicking :+1: on the first post