Changing background colour of a chart based on a expression

[#1]

Dear Community,

I have been struggling with the following problem for some time now and I hope someone can provide support on the following:

I am building a KPI  chart (see below) and I am trying to create an expression which will trigger the background to change green if below budget and red if above budget.  Unfortunately I am finding it a bit challenging due to the complexity of the chart itself.  Each colour in the chart below has its own expression (therefore sum if is required).

I have added the expression that I am trying to create, the first section gives a value.  I am stuck one the second part of the formula.  Below you can find the tables that I am using to assemble the rest of the formula.  "Budget houder" needs to be kept in because it used to filter a list of Cost Centres..

What I need the formula ((if([Budget Houder]='QC',[Budget 2016]*[Current Month])), ) to do is based on the current month (example: 9) needs to sum up the total budget up to Period 9.

Any help will be much appreciated!!!!!!

(sum(if([Site GRP Rapport]='Quality Control' ,[Val.in rep.cur.])) < (if([Budget Houder]='QC',[Budget 2016]*[Current Month])), RGB(121 ,217, 124), RGB(236 ,166, 152)) 

Hard coded formula in excel: =MONTH(TODAY())-1

Current Month

9

Period	Budget 2016	Budget Houder
1	159309.83	Test 1
2	159309.71	Test 1
3	159309.83	Test 1
4	159309.83	Test 1
5	159309.71	Test 1
6	159309.83	Test 1
7	159309.83	Test 1
8	159309.71	Test 1
9	159309.83	Test 1
10	368609.83	Test 1
11	159309.71	Test 1
12	159309.83	Test 1
1	109678.09	Test 2
2	109678.2	Test 2
3	109678.09	Test 2
4	347778.09	Test 2
5	109678.2	Test 2
6	109678.09	Test 2
7	109678.09	Test 2
8	109678.2	Test 2
9	109678.09	Test 2
10	109678.09	Test 2
11	109678.2	Test 2
12	109178.09	Test 2