Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
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
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
Thanks a lot Michael,
You save my night!
Best Regards