Simple Cost Ratio from GL Data

Hello all, pretty frustrated with what I feel should be a simple task

I have a simple set of GL data, as seen below, where my amount is in one column, and my accounts are rows.

I then do a very simple model where I have a GL Account class lookup table, which assigns the class "revenue" and "cost" to each account.

I then just want to have a simple cost ratio at the account level, of cost/total revenue. the table should look as such below, but nothing returns at the account level for a margin. even the revenue accounts are wrong, as Revenue Reg should be 60% of total revenue, , and Revenue Spec should be 40%

My measures are