Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Genuises,
I have a chart in which I have Customer Code, Local Cargo Throughput
Expression as Sum(Cargo_thruput)
Below is the image of the chart attached
Please open the image and then go thru the below problem
So if you see I have range for Local CArgo throughput which is 1-300000 and >300000 these ranges are coming from an excel files
Now when I am doing the Sum(Cargo_thruput) in whichever range it will lie it has to be there in image case if you see Customer Code= CSTEINWEG SUm is 4255376 but it is lying in both the places 1-300000 and >300000 , I need that it will lie only to >300000 and the other row will be eliminated
Please look only for CSTEINWEG
Fast help will be appreciated as I have to deliver it in 2 hours
Thanks in advance
S
Hi Manish,
Thanks for the response.
No Classes are not symmetrical
Hi Angad,
Thanks for the answer , its working fine when I have a range like
1 - 250000 or > 250000
The problem is when I have the range like
25000 - 30000 , 30000-90000
Please help me out and after that I will mark this as correct answer
pls
Thanks,
S
I think it should work with those ranges as well.
For any range,
It is reading the '-' or '>'and then separating lower and upper ranges.
Can you please modify the attachment I sent, with what issues you are having.
Thanks,
Angad