Set analysis problem

[#1]

Hi

I've data like this..

Cavnum	Length	inspCount
1	0	1
1	52.901067	1
1	64.78034	1
2	0	1
2	48.396422	1
2	346.09862	1
3	0	1
3	48.407275	1

- I've two variables(i.e vLB and vUB) in my sheet which i've taken in inputbox. So that user can enter the values here. Let takes vLB = 0 and vUB=46.

- Now i've taken Cavnum as dimension in straight table and 3 expressions as

1. #All -> =sum(inspcount)

2. Small -> =(Sum({$<MeasureLength={"<=$(vLB)"}>} inspcount))

3.Medium -> =(Sum({$<MeasureLength={">$(vLB)<=$(vUB)"}>} inspcount))

4. Large -> =(Sum({$<MeasureLength={">$(vUB)"}>}inspcount))

- I'm not able to get exact values what i want. B'coz i've taken Cavnum, Measure Length in listbox and i'll select 1 as cavnum and 0 from MeasureLength listbox then it shows exact value in the straight table.

Is there any thing wrong in my set analysis..

[swuehl]

Hi,

I think your expressions should work, but please recheck the exact spelling of your field names (case sensitiv).

I think it should be inspCount in your set expression instead of inspcount and Length instead of MeasureLength.

Also check your number format, that the decimal separator is set to '.'

Hope this helps,

Stefan

[#3]

Swuehl,

Sorry the field name is MeasureLength only..

Can you see please the attached image it shows different data in striaght table. When comparing to the selection i made.

[#4]

Try that:

MeasureLength={'$(=num(52.901067))'}

=sum({<MeasureLength={'$(=num(52.901067))'}>}inspcount)

Hope it helps.

Marcos