Using 'min' function within set analysis

[cgT]

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 

[cgT · Accepted solution]

And as soon as I post, I work out the solution:

sum({<TransactionDate = {"=$(=Min(({<SoldValue= {'>=1'}, MrwDescription= {'*DMT+*'}>}TransactionDate)))"}>}SoldValue)