Convert to set analysis

[gauravgg]

Hi

I want to convert the following expression in to set analysis

Sum(If( Aggr(nodistinct Min(Datetime), BusinessID) = Datetime, OpeningBalance))

[Anil_Babu_Samineni]

It won't work for you. Try with jontydkpi or else

stalwar1‌ mrkachhiaimp‌ marcowedel‌

[sunny_talwar]

May be this:

Sum({<BusinessID = {"=Min(TOTAL Datetime) = Datetime"}>} OpeningBalance)

[gauravgg]

HI

sunny ,it is not working

[sunny_talwar]

Would you be able to provide a sample?

[MK_QSL]

Don't know how to convert this in set analysis but you can use below as well..

=FirstSortedValue(DISTINCT Aggr(SUM(OpeningBalance),BusinessID,Datetime),Datetime)

instead of this

Sum(If( Aggr(nodistinct Min(Datetime), BusinessID) = Datetime, OpeningBalance))

[MarcoWedel]

please post some sample data to test with as well as your expected result.

thanks

regards

Marco