9 Replies Latest reply: Dec 12, 2012 4:39 PM by Stelios Genouzos RSS

    Set Analysis combine FirstSortedValue()

    Stelios Genouzos

      Hello,

      I have the below expression:

       

      sum({$<TransDate={"=firstsortedvalue({$<CashAmount={'>0'},DATE= {'<$(=OpeningDate)'} >} DATE,-DATE)"}>}Amount).

       

      The firstsortedvalue returns one single date.Alone it works fine.But when i put it on the sum() i get the sum for all values(dates) of field TransDate  instead of

      get sum for only single date equal to TransDate.

      Any help will be appreciate!