Background Colour (Full Accumulation)

[#1]

Hi All

I’m trying to add a dynamic background colour based on the total accumulation for each respective month.

I’ve got Test and Test2 applications where I apply the exact same thing but not getting the same results.

What is the reason that Test2 is not working?…I’ve checked and really don’t get what is the problem.

I want to use this on Test2 as I have built a data model already.

Thanks!

[MK_QSL · Accepted solution]

I can see that it's actually working... In reality you don't have any accumulated value >3000 so all bars are red.

You can try instead

IF(RangeSum(Above(SUM(SavingsAccount),0,RowNo()))<=2000,LightRed(),Green())

You can see that any bar having >2000 now becoming green.

[#3]

Hi Manish

Thanks for the solution. works perfectly! I'm still a bit confused though...still don't understand why mine didn't work...anyway I'll give some thought

Thanks again!