Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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()))
IF(not WildMatch(Name ,'*CAP*')
try this in you script