Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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) |
Hi,
Always try to explain the question clearly. Your last question is deviating from your initial question. Check the attachment.
Hi
Logic columns is needed only for Sub = A2?
Regards
Harish
yes, that is my max sub area, from max sub only i need to caluculate .
HI
PFA the .qvw for your reference. I've implemented the logic you want.
Regards
Pratyush
Please find the attached QVW.
Hope this helps!
Regards
Harish
Try This
(RangeSum(Sum([Exp 1]),Sum([Exp 2])))-Above(Sum([Exp 2]),1)
Output:
Regards
Harish
Hi Subbareddy,
Please find the attached application. It contains the output you want. Hope this helps.
Thanks,
Akash.
Harish, What logic you have written over there? I don;t have S/W in hand