Complex set analysis works only for equal sign(=)

[steliosg]

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!

[Anonymous · Accepted solution]

See if this helps, always works for me, my additions in bold:

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

Regards,

Michael

[steliosg]

Thanks a lot  Michael,

You save my night!

Best Regards