Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a set analysis that not work. Whats wrong please?
count({<DIA0=-{}>} distinct OID_METER) Not recognize Null
IF (ISNULL(DIA0),'EMPTY') Recognize Null
In my very first response I mentioned this
What this means is that if a row has DIA0 as null, set analysis won't be able to put any filtration on that specific row based on DIA0... example
OID_METER DIA0
1 4
2 Null()
3 2
4 4
5 Null()
When you will use any set analysis on DIA0, consider it to start looking at 1, 3, & 4 rows only because the other two DIA0 are null....
But by using a set analysis on OID_METER, you can check if the Len(Trim(DIA0)) = 0 or not... if it is then count DIA0, else not..... But this can only work when there is a one to one relation between the ID field and DIA0... what this means is... if for example you have this
OID_METER DIA0
1 4
2 Null()
3 2
4 4
5 Null()
5 4
It might not work the way you would want.... If you would want it to still count OID_METER 5, then it may not because there is another OID_METER 5 where DIA0 is not null....
I hope this helps.
Best,
Sunny
I understand, but look at my previous version of this app
count({<DIA0=-{}>} DISTINCT OID_METER)
and works !!! For that reason that i can understand why sometimes "Null values cannot be compare to anything in set analysis" are true and sometimes (like example below) are not.
