How back ground colour is designed for the satisfaction of two expressions?

[nevilledhamsiri]

Hi Members,

Appreciate if reference is made to case where two conditions to be met if that is to be ok if not needs to be treated as not ok. I wish to show this in back ground colour. Simply what I need is something like below!

If UPR & DAC balances are both negative, such cases are ok. Similarly if UPR & DAC balances are both positive still it is alright but if the combination is the opposite such as (one is positive whereas other is negative & so on) then they are not alright & need to show  red in colour. The expression used is as follows. but it doesn't show me the expected out put. Please help.

IF(Sum (UPR) AND SUM(DAC)<0,LightGreen(),IF(Sum (UPR) AND SUM(DAC)>0,LightGreen(),LightRed()))

[adityaakshaya · Accepted solution]

Hi Nevellie,

I downloaded the attachment  and it is a blank application.

You can use below expression

IF(Sum (UPR)<0 AND SUM(DAC)<0,LightGreen(),IF(Sum (UPR)>0 AND SUM(DAC)>0,LightGreen(),LightRed()))

Regards,

Akshaya

[nevilledhamsiri]

Thanks Adithya,

It is alright. If the expected colouring to be highlighted both on UPR & DAC at once , can it be done in single expression such s one you proposed or is it required to apply the same on DAC as well.

Regds

Neville

[adityaakshaya]

As per my understanding you are using a straight table chart. and you have two measures UPR and DAC.

If the above understanding is correct, then yes, you have to use background color expression in both UPR and DAC.

Regards,

Akshaya

[nevilledhamsiri]

If it is a Pivot chart, does the answer is same or otherwise

Regds

Neville

[adityaakshaya]

Yes, You have to add it in both the measures.

Regards,

Akshaya

[nevilledhamsiri]

Thank very much Akshya

Look forward to same response in due course

Regds

Neville