Set Analysis Difference

[#1]

Hi All,

Could someone please shed a bit of light on this dillema, when no selections have been made, why would the following expressions give different results:

1) Count({$<[Float beds] = {'Good'}>} NTIMB) and

2) Count(If([Float beds] = 'Good',NTIMB,0))

The first one gives me the correct results, but objects won't change when I make selections from list boxes, which I need it to.

Thanks

H

[alexandros17 · Accepted solution]

Pay attention, the secount expression counts even zero values ...

transform in

Sum(If([Float beds] = 'Good',1,0))

Let me know

[Clever_Anjos]

I think you should SUM, instead of count, because counting 0´s returns them too

1) Count({$<[Float beds] = {'Good'}>} NTIMB) and

2) SUM(If([Float beds] = 'Good',NTIMB,0))

[#4]

Thanks guys,

I think I was half asleep....

Herbert