Determin latest Throuputrate

[#1]

Hello,

I have different throughput rates for one product. These throughput rates have different start and end times. Now I want to know the latest thruputrate which was entered in the System.

I try to get this with the following Statements:

sum({<StartDate={'$(=max(StartDate))'}>}(mmaxStart))

Unfortunately this only delivers data for the some of the Products. Only those which have the same Change date.

For example 5 Products got a new throughput rate at the 01.01.2017. 10 Products were Change at the 01.12.2016. The result is that only for the 5 products my throughput rate is displayed. The other ones get displayed as 0.

When I query the

=max(StartDate) for each Product it displayes me the correct Date.

Any ideas what I am overlooking?

Thanks for your help.

Stefan

[sunny_talwar · Accepted solution]

May be this

Sum(Aggr(If(StartDate = Max(TOTAL <Products> StartDate), Sum(mmaxStart)), Product, StartDate))

[#3]

Hi Sunny,

es this works. Great. I was sitting over this for the whole morning.

Thank you very much.

Stefan