Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Pay attention, the secount expression counts even zero values ...
transform in
Sum(If([Float beds] = 'Good',1,0))
Let me know
Pay attention, the secount expression counts even zero values ...
transform in
Sum(If([Float beds] = 'Good',1,0))
Let me know
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))
Thanks guys,
I think I was half asleep....
Herbert