Multiplication in bubble chart

[infock12]

Hi all,

I am creating a bubble chart for risk monitoring. The table has 4 columns. Sample data attached

No:

Consequence

Likelihood

Total

I am using Likelihood and Consequence as Dimensions and count (No:) as expression.

I wanted to restrict the bubbles only to 3 colours (Red, Amber, Green). The formula I wanted to write is

=if(count(Consequence) * count (Likelihood) >12, RGB(255,36,0), if(count(Consequence) * count(Likelihood) <=12 and if(count(Consequence) * count(Likelihood) >8, RGB(218, 145, 0)), LightGreen()))

I wrote this under "Colours" tab on the first colour but it did not work. Not sure if I have to add an Aggr function before count? Secondly, where do I enter this formula, i.e., under "Colours" tab or "Expressions > Background colour"?

Finally, I am not able show the value of count (No:) on the bubbles. "Labels on Data Points" under "Presentation" tab is ticked but under Expression tab is deactive. How would I  bring the data points. Any help is much appreciated!

Regards,

K