0 Replies Latest reply: Jul 12, 2013 4:16 AM by Phil Speight RSS

    Multiple field count - Conditional

    Phil Speight

      I have 2 problems here connected.  The first problem is that my expression results show as '-1' so they do not count (but still display the correct fields

       

      My second dilema is that I want to merge my expression to display a chart with all the data in one place..

       

      The problem I have is that I have 2 conditions that I need to apply over 2 fields, which compounds the complexity.

       

      1st condition

       

       

      Count({$<[StartDate]={'In Process'}>} [StartDate])

      and

      count({$<[ReferenceID]-={''}>} [ReferenceID])

       

      The above will count and field which has 'In Process' and where there is no ReferenceID

       

       

       

      2nd Condition

       

       

      Count({$<[StartDate]-={'In Process'}>} [StartDate])

      and

      count({$<
      [ReferenceID]={''}>} [ReferenceID])

       

       

      This one will count any field which has a start date, but does not have a reference number.

       

      Both of these work in isolation (2 seperate Charts), but I do not know how to put them together to get a full set of data.

       

       

      Any help appreciated

       

       

       

      Phil