Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
I almost find the solution, but faced on some difficulties.
Please find attached a sample.
I need a fresh view.
Thanks.
Andrei
Like this?
Almost
I got this result in text object.
I need Sum( TRN) where STARTDATE=(min(STARTDATE which >=TRIALPERIOD))
I need get
AAA | 800
Thanks
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
Thanks a lot!
I supposed that the problem was in quotes, but couldn't find how to deal with them.