10 Replies Latest reply: Feb 19, 2014 8:21 AM by Александр Закревский RSS

    Conditional chart (plain table) output

    Александр Закревский

      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!