MIN with Aggr and Rangesum

timo_brenner — Tue, 18 Jan 2022 08:42:44 GMT

Hello everybody,

I have the following Data:

The Column "voraussichtlich Verfügbar bis Fälligkeit" calculates the stock for each "Komponentennr." until a certain date ("Komponentenfälligkeit"). The Formula is:

[Bestand_Komponentennr.]-
Aggr(rangesum(above( sum(Komponentenrestmenge),0,rowno())),[Komponentennr.],([Komponentenfälligkeit],(Numeric, ascending)))

Now I want to creat a new column which should show the minimum of the calculated stock for each combination of "FA-Nr.", "FA-Zeilennr." and "Arbeitsgangnummer".

In the first five rows the callback has to be 191, in the last three rows it has to be -147.

I tried following formula:

MIN(aggr(
Aggr(rangesum(above( sum(Komponentenrestmenge),0,rowno())),[Komponentennr.],([Komponentenfälligkeit],(Numeric, ascending))),[FA-Nr.],[FA-Zeilennr.],[Arbeitsgangnr.]))

The formula doesn't work. There isn't a result in any row.

What am I doing wrong?

Thanks for your help.

Best regards

Timo Brenner

topic MIN with Aggr and Rangesum in App Development

MIN with Aggr and Rangesum