Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 , + ?
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())
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())