Using variable

[qv_testing]

HI Community,

i have one straight table..  based on selections i am getting data.

Like

From:  100

To: 200

Here populating table between select ranges.. (100 to 200 between data i am getting)

Exp:  IF(vMin='--Select--' or vMax='Select', sum(sales),

              if(sum(sales)>=vMin and sum(sales)<=vMax, sum(sales))

This expression working fine..

But my requirement...

If i am enter any one From or To  i want to populate data..

Suppose if i am enter 100... i want to show data less than sum(sales)<=100.

I have written  this..

IF(vMin='--Select--' or vMax='Select', sum(sales),

     IF(vMin=vMin or vMax='--Select--', sum(sales)<=100,

              if(sum(sales)>=vMin and sum(sales)<=vMax, sum(sales))

But it's not working..

Please can anyone help me..

Thanks in Advance..

[sunny_talwar]

May be this:

If(vMin='--Select--' and vMax='Select', Sum(sales),

    If(vMin=vMin and vMax='--Select--', If(Sum(sales)<=vMin, Sum(sales)),

              If(Sum(sales) >= vMin and Sum(sales) <= vMax, Sum(sales))))

[qv_testing]

Did i anything wrong??

Please can you check once..

if i am enter 300000.. i want to show 1 record only..

PFA,

[sunny_talwar]

Can you check now?

[qv_testing]

Thanks for response..

If i am enter 300000, that should be only one record.

and Contribution% not showing....

Thank you....

[sunny_talwar · Accepted solution]

Check now

[qv_testing]

I got it.. Anyway thanks

[sunny_talwar]

It was still not what you were looking for?

[qv_testing]

This is not my real data, i don't have access to post real data.

That's why i have made sample Application.

Here i am getting proper everything..

Actually these expression i written in my real data..  But percentages not getting proper way... I don't know why

I am confusing with real data... ..

I am fed up with data..

Everything i am getting proper, percentages  getting wrong figure.

That's why i am looking for better way of write expression.

Because of that i am keep posting one issue...

[sunny_talwar]

Not sure, but have you got a chance to look at this link?

Preparing examples for Upload - Reduction and Data Scrambling