Min/Max per line

[hschultz]

Hi all

I hope you can assist me please.

I want to get the minimum and maximum value difference out of all time sections that build up a specific line.

The time is for hours in the day.

The sheet is grouped by Day.

So it should look something like this (using basic calculations):

Day	Outlet	Capacity	Quantity	Minimum	Maximum
Mon	Site A	24	24	1	1
Mon	Site B	24	25	1	2
Tue	Site A	24	0	0	0
Tue	Site B	24	49	2	3

The problem is with my current code, Minimum = 0 in all lines, and Maximum = 3 in all lines. This is the code i am using:

Min(total aggr(sum(DATA1_Qty / INTERVAL_Capacity1), Time))

*Replacing Min with Max in the next colum

The plan is to use this in a traffic light display, where if 1 hour has abnormal capacity vs usage to be different colors. But it needs to show combined by day.

Any assistance will be greatly appreciated.

[CELAMBARASAN]

Hi,

     Did you tried without TOTAL

     Min(aggr(sum(DATA1_Qty / INTERVAL_Capacity1), Time))

     or

     Min(total<Day,Outlet> aggr(sum(DATA1_Qty / INTERVAL_Capacity1), Time))

Celambarasan

[hschultz]

Help file was quite insistant in using total in your code.

It seems to be working better at least. However - 

There appears to be values of - (Null). But if i click on the Null then there is detail inside it. So surely can't be Null.