4 Replies Latest reply: May 7, 2013 6:34 AM by Vishwaranjan Kumar RSS

    Logical expression inside main expression

      Hi. I'm trying to build some expression which should be calculated by logical terms.

       

      my way1:

       

      =sum({<Period1={'>=$(=min(Period0)) <=$(=max(Period0))'}>} Counter)

       

      my way2:

       

      =sum({$<Period1= {'$(=Period0)=(=Period1)'}>} Counter)

       

      i'm trying to do something like this:

       

      sum({$<OrderDate = DeliveryDate>} Sales) - from help of set analysis

       

      but it's not working...

       

       

      Period1 and Period0 it's dimensions.

       

      When i using in chart my first Period1 dimension all working okay. But when i trying to use the second - damn.

       

      =sum({<Period1={'>=$(=min(Period0)) <=$(=max(Period0))'}>} Counter)

       

      my logic is:

       

      IF Period1=Period0 THEN I TAKES RECEIVED DATE INTO Period1 AND THEN COUNTING FOR THAT DATE.

       

      Help if it's possible )) thnx