Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
Here is a sample of my data set:
Estimate_Number Quote_number Description Estimate
368 0 Hotel 1000
368 0 Plane 500
368 0 Food 300
368 1 Plane 400
368 1 Food 400
368 1 Car 500
I had a similar question a couple of weeks back where I wanted to get the value of Description where the Quote_Number was at its max value. Sunny correctly helped me out with this:
Sum(Aggr(FirstSortedValue(Estimate, -Quote_number ), Description ))
I didn't realize that we are only concerned with the Descriptions where the Quote_Number is at its max value. So in this example, I don't want the Hotel estimate to be included, and only want the sum (1300) of Plane. Food, and Car where Quote_Number is 1 (Max).
I appreciate any help with this,
Ben
Where do you want this to be displayed? You can try like
= Sum({<Quote_number = {"= Max(Quote_number)"} >} Estimate)
OR
= Sum(Aggr(Sum({<Quote_number = {"= Max(Quote_number)"} >} Estimate), Description))
Where do you want this to be displayed? You can try like
= Sum({<Quote_number = {"= Max(Quote_number)"} >} Estimate)
OR
= Sum(Aggr(Sum({<Quote_number = {"= Max(Quote_number)"} >} Estimate), Description))
Thank you Vishwarath! I ended up using your second option, and it works perfectly.