1 Reply Latest reply: Nov 26, 2013 11:40 PM by Tresesco B RSS

    Set Analysis - Date Comparision Greater Than Another Field

    Janakiram Sundaram

      Hello

       

      I am looking for help with the following set analysis expression.

       

      sum(

        {$

        <SfdcOpptyID =

                  p({$<Snapshot.Date={$(=Num(vPickSnapshotDate_1))},Closed.QuarterStartDate={"<$(=Snapshot.QuarterStartDate)"}>} SfdcOpptyID) *

                  p({$<Snapshot.Date={$(=Num(vPickSnapshotDate_2))},Closed.QuarterStartDate={"<$(=Snapshot.QuarterStartDate)"}>} SfdcOpptyID)

          ,Snapshot.Date={$(=Num(vPickSnapshotDate_1))}

        >

        }

        TotalPrice

      )

       

       

      The part of the expression that i have trouble is Closed.QuarterStartDate={"<$(=Snapshot.QuarterStartDate)"}

       

       

      I created small test .qvw with few rows and it same logic (expression , syntax) works(attach). But if i try to implement this in my main report it does not return value. If i replace the logic to use IF statement then the report brings back numbers.

       

      Please advise!