Aggr help

[dhanu_today]

Hi Every one,

How we got the output as below.

Output:

TYPE	POSITIVE	NEGATIVE	GROWTH
MANUFACTURE	860	-400	460
DELIVERED	420.5	-250.02	170.48
IN PROCESS	2472	-34	2438

Input Data:

TYPE	NUMBER	VALUE
MANUFACTURE	5	100
MANUFACTURE	10	-110
MANUFACTURE	15	120
MANUFACTURE	20	-130
MANUFACTURE	25	140
MANUFACTURE	30	150
MANUFACTURE	35	-160
MANUFACTURE	40	170
MANUFACTURE	45	180
DELIVERED	12	200
DELIVERED	17	0
DELIVERED	18	220
DELIVERED	19	-0.02
DELIVERED	20	0.05
DELIVERED	21	-250
IN PROCESS	67	400
IN PROCESS	38	430
IN PROCESS	343	-34
IN PROCESS	464	466
IN PROCESS	46	565
IN PROCESS	46	645

Thanks,

Dhanu

[luis_pimentel · Accepted solution]

You don't need de AGGR function. Use a table with type as dimension, and for the expressions:

POSITIVE: if (VALUE > 0 ,sum(VALUE))

NEGATIVE: if (VALUE < 0 ,sum(VALUE))

GROWTH: sum(VALUE)

[hic]

If your goal is to split up the "VALUE" in negative and positive numbers, you don't need any Aggr().

Sum( if(VALUE>0,VALUE) ) as POSITIVE

Sum( if(VALUE<0,VALUE) ) as NEGATIVE

Sum( VALUE ) as GROWTH

or the same with Set Analysis

Sum( {$<VALUE={">0"}>} VALUE ) as POSITIVE

Sum( {$<VALUE={"<0"}>} VALUE ) as NEGATIVE

Sum( VALUE ) as GROWTH

HIC

[alexandros17]

Here it is ...

Hope it helps

[MK_QSL]

Like this..

[ashwanin]

HI Dhanu,

Use formula

Sum( {$<VALUE={">0"}>} VALUE)  for +ve Values

Sum( {$<VALUE={"<0"}>} VALUE)  for -ve Values

Sum( VALUE ) for growth.

Please find the qvw for same.

[dhanu_today]

Thanks all ...All are working...