Two dimensions on color expression condition

[JoseGarcia]

Hi all, 

Can anyone assist with the following:

I would like to combine two dimensions to apply a color expression.

=if(if(sum([gg_availability])<17, RGB(249,63,23), RGB(70,198,70),),

if(sum([mn_availability])<23, RGB(249,63,23), RGB(70,198,70),))

this syntax is giving me error.

Thanks all.

Regards

Jose

[sunny_talwar · Accepted solution]

May be this

=If(Sum([gg_availability]) < 17 or Sum([mn_availability]) < 23, RGB(249,63,23), RGB(70,198,70))

If it is an AND condition, then this

=If(Sum([gg_availability]) < 17 and Sum([mn_availability]) < 23, RGB(249,63,23), RGB(70,198,70))

[JoseGarcia]

First Syntax worked!

thanks a million Sunny!

Really appreciate your help as always! 🙂

regards

Jose