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

# Complex set analysis works only for equal sign(=)

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!

• ###### Re: Complex set analysis works only for equal sign(=)

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

• ###### Re: Complex set analysis works only for equal sign(=)

Thanks a lot  Michael,

You save my night!

Best Regards