2 Replies Latest reply: Dec 12, 2012 5:04 PM by Stelios Genouzos RSS

    Complex set analysis works only for equal sign(=)

    Stelios Genouzos

      Hello,

      I'd like to make the below function works with sign >= instead of =

      The initilal expression is

      sum({$<CODE={'10'}, Date={"=Date(firstsortedvalue( {$<CashAmount={'>0'},Date= {'<$(=OpeningDate)'} >} Date,-Date),'DD/M/YYYY')"}>}Amount)

      and it works.

       

      The ideal is

      sum({$<CODE={'10'}, Date={">=Date(firstsortedvalue( {$<CashAmount={'>0'},Date= {'<$(=OpeningDate)'} >} Date,-Date),'DD/M/YYYY')"}>}Amount)

      but it doesn't work.

      Any help will be welcomed!