Change bar colours for negative numbers

Hopefully you can help me or point me in the right direction. I am trying to show a chart where everything below the link is Green and above is Red I had it working before but it may be the way my data is stored ---  see link to chart   I have written the logic in Beast Mode under the field GetStatusD.



when sum((CASE  WHEN (`type`='Actuals') THEN `amount_usd` ELSE 0 END ))-Sum((CASE  WHEN (`type`='Budget') THEN `amount_usd` ELSE 0 END ))> 0 then 'Above Target'


'Below Target'



It is working in chart -



This discussion has been closed.