10 Replies Latest reply: Nov 30, 2017 6:17 AM by Ibrahim Aslan RSS

    Set Analysis combine FirstSortedValue()

    Stelios Genouzos


      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!