Background color depending on another results

[#1]

Hi,

I need to use a formula that changes the background of the cell depending on the result of the expression (i am coparing between the Forecast and the budget).

If the forecast is >= Budget then green else red. But this doesn't work for me.

Can you help me to correct this expression.

Please find attached my application.

Thanks

[#2]

Hello Imen,

In your background color expression:

sum({ <YEAR_EXERCISE ={"= $(v_SelectedYear)"},SPQVC_ORDER={'V01'},EXERCISE ={'BUDGET'}>} Amount)

Returns 0 for every value that is not associated with EXERCISE = 'BUDGET'.

So I replaced the above with your v_Budget, which is equal to 21,579,268.37.

The problem with this is that it is greater than every single one of your act/fcst.

This might be something you can fix in your load script. The problem is that your other Exercises cannot be compared to your Budget Exercises.

[#3]

Hi Jacob,

Thanks for your response 

In fact i have to compare month by month the budget and the froecast. In the table tht i am using you can see in the bottom the value of the budget ... i have to compare it with the value of the 1st forecast month and if it is greater than red else green.

A fixed value (a sum of all the budget) is not what i am looking for in my expression.

Do you have any suggestion?

Thanks

[#4]

Budget:

Load

EXERCISE as Budget

where EXERCISE like 'BUDGET';

If you put this in your load script underneath the PCnL tab, you could use this new Budget field to make comparisons maybe.