2 Replies Latest reply: Aug 28, 2014 12:02 AM by jagan mohan rao appala RSS

    Date range in set analysis help

      I'm trying to do set analysis and the date portion isn't doing anything... What is wrong with my syntax? I've attached the file - I tried it two ways.


      In the attached file select Dim1 = A and Date = 8/28.

      Selected sum Expression1 = 1449


      Trying to do the same with set analysis but the sum =2050


      ='selected sum 1: ' & Sum (Expression1) & ' count of rows: ' & Count (Num) & ' Sum of expression1 where Dim1 = A and AccountStatus= Cancelled and date range: ' & Sum({1<Dim1={'A'},AccountStatus={'Cancelled'},date={">vStart<vEnd"}>}Expression1)


      How do I fix this?