Conditional Background color in Expression

[schivet]

Hi,

This sounds like a simple problem but I can't manage it .

I would like to get this directly in my object:

I need to have a different background color when the amount is different to the other ones, knowing that the sum for Source 1 can be only the sum of one row when Source 2 can be a sum of several rows:

Name	Curr	Source	Amount
Article 1	EUR	Source 2	850
Article 1	EUR	Source 2	-850
Article 1	EUR	Source 4	-850
Article 1	EUR	Source 1	1 592
Article 1	EUR	Source 2	1 592
Article 1	EUR	Source 3	1 592
Article 1	EUR	Source 4	1 592

[swuehl]

Maybe try a background color expression like

=If(Sum(Amount) <> Only({<Source = {'Source 1'}>} TOTAL<Name, Curr> Amount), LightRed())

[schivet]

Hi Swuehl!

Thank you! That's a really good start but won't work all the time because Source 1 is not alway the reference... I have added an example here when Source 1 is not the correct value and should be the one in color and not the others:

Any idea?

Thanks for your help

[swuehl]

Try a background color expression like

=If(Sum(Amount) <> Mode(TOTAL<Name,Curr> Aggr( sum(Amount),Name,Curr,Source)), LightRed())

[effinty2112 · Accepted solution]

Hi Stephane,

Try this as your colour expression:

=If(Sum(Amount)<>Mode(TOTAL <Name> Aggr(Sum(Amount),Name, Source)), LightRed())

Name	Source	Source 1	Source 2	Source 3	Source 4
Article 1		1592	1592	1592	742
Article 2		800	1592	1592	1592

This colours the cell if the value differs from the most common value for that Article.

Cheers