Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I currently have a date that has been set by the following expression:
=Date(Min({<PerformanceDate=, SoldValue= {">=1"}, MrwDescription= {"*DMT+*"}>}TransactionDate), 'DD/MM/YYYY')
This works perfectly. I am now trying to define the sum(SoldValue) for this TransactionDate. Here is what I have so far that, naturally, isn't working:
sum({<TransactionDate = {"$(=Min({<PerformanceDate=, SoldValue= {'>=1'}, MrwDescription= {'*DMT+*'}>}))"}>} SoldValue )
It currently returns now value for the transaction date.
Could someone help please?
Many thanks in advance
And as soon as I post, I work out the solution:
sum({<TransactionDate = {"=$(=Min(({<SoldValue= {'>=1'}, MrwDescription= {'*DMT+*'}>}TransactionDate)))"}>}SoldValue)
And as soon as I post, I work out the solution:
sum({<TransactionDate = {"=$(=Min(({<SoldValue= {'>=1'}, MrwDescription= {'*DMT+*'}>}TransactionDate)))"}>}SoldValue)