logic help

[subbareddykm]

Hi All ,

can anyone tell me how get this output?

This is my data.

Sample:

LOAD * INLINE [

    Company, Sub, Id, Exp 1, Exp 2

    ABC, A1, 1, 5, 8

    ABC, A1, 2, 10, 13

    ABC, A1, 3, 13, 16

    ABC, A1, 4, 15, 18

    ABC, A1, 5, 17, 20

    ABC, A2, 6, 19, 22

    ABC, A2, 7, 20, 23

    ABC, A2, 8, 25, 28

    ABC, A2, 9, 30, 33

];

Output:

Company	Sub	Id	Exp 1	Exp 2	Logic
ABC	A1	1	5	8
ABC		2	10	13
ABC		3	13	16
ABC		4	15	18
ABC		5	17	20
ABC	A2	6	19	22	19
ABC		7	20	23	20+(23-22)
ABC		8	25	28	25+(28-23)
ABC		9	30	33	30+(33-28)

[harishkumarg]

Hi

Logic columns is needed only for Sub = A2?

Regards

Harish

[subbareddykm]

[subbareddykm]

yes, that is my max sub area, from max sub only i need to caluculate .

[prat1507]

HI

PFA the .qvw for your reference. I've implemented the logic you want.

Regards

Pratyush

[harishkumarg]

Please find the attached QVW.

Hope this helps!

Regards

Harish

[Anil_Babu_Samineni]

Try This

(RangeSum(Sum([Exp 1]),Sum([Exp 2])))-Above(Sum([Exp 2]),1)

[harishkumarg]

Output:

Regards

Harish

[akash3191]

Hi Subbareddy,

Please find the attached application. It contains the output you want. Hope this helps.

Thanks,

Akash.

[Anil_Babu_Samineni]

Harish, What logic you have written over there? I don;t have S/W in hand