Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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()))
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
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
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
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
If it is a Pivot chart, does the answer is same or otherwise
Regds
Neville
Yes, You have to add it in both the measures.
Regards,
Akshaya
Thank very much Akshya
Look forward to same response in due course
Regds
Neville