Nested Set Analisys Issue

[crusader_]

Hello Community,

How to find Amount where

Tran_date=min(Tran_date) from set where Tran_date={">=$(=num(TRIALPERIOD))"}

using Set Analisys only.

I need to find first transaction after expiring Trial Period.

Thanks in advance.

Andrei

[crusader_]

Hi,

I almost find the solution, but faced on some difficulties.

Please find attached a sample.

I need a fresh view.

Thanks.

Andrei

[tresesco]

Like this?

[crusader_]

Almost

I got this result in text object.

I need Sum( TRN) where STARTDATE=(min(STARTDATE which >=TRIALPERIOD))

I need get

AAA  |  800

Thanks

[#5 · Accepted solution]

Hello Andrei,

Please use below as expressions:

=sum({$<STARTDATE = {"$(=date(min({$<STARTDATE={'>=$(=num(TRIALPERIOD))'}>} STARTDATE)))"} >} TRN)

Also find PFA. Hope it was helpful

Thanks,

Angad

[crusader_]

Thanks a lot!

I supposed that the problem was in quotes, but couldn't find how to deal with them.