Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a following table:
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