Multiple conditions in color expression not working !

[claudialet]

 Hello here is my conditional color expression :

For all 'Name' that has 'cap'  and amount is above 5.5  show in green if less red 

For all 'Name' that is not 'cap' and amount above 7.5 show in green if less red

= If(Only({<Date={"$(=max(Date))"}, Name = {'*cap*'}>} amount) > 5.5 ,  Green(),Red(),

 If(Only({<Date={"$(=max(Date))"}, Name ! = {'*cap*'}>} amount) > 7.5 ,  Green(),Red()))

[Marcos_rv]

= If(Only({<Date={"$(=max(Date))"}, Name = {'*cap*'}>} amount) > 5.5 , Green(),Red(),

If(Only({<Date={"$(=max(Date))"}, Name - = {'*cap*'}>} amount) > 7.5 , Green(),Red()))


es importante el '-=' .

Saludos!!!

[Marcos_rv]

try this:

= If(sum({<Date={"$(=max(Date))"}, Name = {'*cap*'}>} amount) > 5.5 , Green(),Red(),

If(sum({<Date={"$(=max(Date))"}, Name - = {'*cap*'}>} amount) > 7.5 , Green(),Red()))

el ONLY solo esta bien si usas AMOUNT como dimensión.

Saludos!!!

[claudialet]

This expression is to be used in a KPI extension and it only works for 1 expression not 2.

Any other way to write ?

[Channa]

IF(not WildMatch(Name ,'*CAP*') 

try this in you script

[Marcos_rv]

= If(sum({<Date={"$(=max(Date))"}, Name = {'*cap*'}>} amount) > 5.5 , Green(),

If(sum({<Date={"$(=max(Date))"}, Name - = {'*cap*'}>} amount) > 7.5 , Green(),Red()))