Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sum(If( Aggr(nodistinct Min(Datetime), BusinessID) = Datetime, OpeningBalance))
Hi Please find the attached excel for data
What is the expected output here?
Hi
I have to convert
Sum(If( Aggr(nodistinct Min(Datetime), BusinessID) = Datetime, OpeningBalance))
into set analysis.
I think he wants Opening Balance total for each BusinessID on Minimum DateTime.
I think this should work
Dimension:
BussinessID
Expression:
FirstSortedValue([Opening Balance], -Datetime)
yes
Hi,
Sum({<Datetime={'$(=Date(Min(Datetime)))'}>} OpeningBalance)
hi sunny
I have to group businessid and get the min date of that particular businessid and its opening balance value
I guess try this:
Dimension:
BussinessID
Expression:
Date(Min(Datetime)
FirstSortedValue([Opening Balance], Datetime)
=sum({<Datetime={'$(=Aggr(MinString(Datetime),BusinessID))'}>}[Opening Balance])