Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In SQL Server, script below counts if data exists with conditions. I want to know how it is done in Set Analysis.
IF (SELECT Count(*) FROM Customer WHERE CustomerType IN ('10','25,'50') > 1)
SET BackColor = 'Blue'
ELSE
SET BackColor = 'Red'
Perhaps this
If(Count({<CustomerType={'10','25,'50'}>}CustomerType)>1, Blue(), Red())
Try like:
Count({<CustomerType={'10','25,'50'}>}CustomerType)
Perhaps this
If(Count({<CustomerType={'10','25,'50'}>}CustomerType)>1, Blue(), Red())