Combine 2 conditional expression into one ?

[claudialet]

Here are my expressions :

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

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

How can I combine them without using and, or  , +  ?

[Lauri · Accepted solution]

You could create a complicated set expression that encompasses both, but I wouldn't recommend that. Why are you against using OR?

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