7 Replies Latest reply: Apr 26, 2017 2:05 PM by Mahender Pannala RSS

    Set Analysis using Date Less than or Equal to

    Mahender Pannala

      I have a requirement to count the transactions that are Less than or equal to a Date. I wrote an expression using IF Statement but that is performing bad. Is there a better way to write in set analysis.


      Below is the IF Statement which gives me right answer:

      SUM(IF([Transaction Term Date] <= [R12M PERIOD] AND [Movement Type] = 'Staffing Hires', Transactions)


      Below is the set Analysis expression which is not working


      SUM({<[Transaction Term Date] = {"<= [R12M PERIOD]"},[Movement Type] = {'Staffing Hires'} >}Transactions).


      Appreciate the help!!


      Thank You