Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table of CID (Company ID), StartDate, EndDate (containing start and end of insurance contracts). My plain table chart should have a list of companies (CIDs) that don't have any insurance on a desired date (taken from a variable set by input box). I've taken CID as a Dimension and CID and
Count({$<[StartDate]={"<=$(TargetDate)"},[EndDate]={">=$(TargetDate)"}>}Distinct CID)
as Expressions. How can I limit the the counted expression to be displayed by the ">0"? And, by the way, what does "Conditional" oprion in expressions do? I failed to find any info in the manuals and could not understand the logic of setting it. Thanks in advance!
That does explain the difference, but unfortunately doesn't help me to solve the core problem.