Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a following table:
| LOCATION ID | LOCATION TYPE |
| LOCATION 1 | TEMP |
| LOCATION 2 | TEMP |
| LOCATION 3 | OUT |
| LOCATION 4 | OUT |
| LOCATION 5 | IN |
| LOCATION 6 | null (empty) |
| LOCATION 7 | null (empty) |
| LOCATION 8 | COP |
| LOCATION 9 | COP |
| LOCATION 10 | XDC |
| LOCATION 11 | XDC |
| LOCATION 12 | XDC |
I have a problem with null. I'm using
Count({<LOCATION_TYPE ={'XDC','TEMP','NULL'}>} distinct LOCATION_ID) and I recieved only TEMP and XDC. What should I do to get also location where LOCATION TYPE is empty?
=Count(DISTINCT {<[Change Order Number]={"=Len(Trim(Check))=0 or Check = 1"}>}[Change Order Number])
Or
=Count({<Check={"=Len(Trim(Check))=0"} > + <Check={"1"}>}[Change Order Number])
Can you try similar to the above