Problem with the range

[Anonymous]

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

[Anonymous]

Hi Manish,

Thanks for the response.

No Classes are not symmetrical

[Anonymous]

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

[#4]

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