Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
i have a table:
TRACK NUMBER | POD_FLAG |
---|---|
1234 | - |
5678 | 1 |
9012 | 0 |
3456 | 1 |
7890 | - |
2345 | 1 |
i want to count just the track numbers that have value in POD_FLAG
in this example the answer should be 4
what the condition i shuld write?
May be this
Count({<POD_FLAG = {"*"}>}[TRACK NUMBER])
or
Count({<[TRACK NUMBER] = {"=Len(Trim(POD_FLAG)) > 0"}>}[TRACK NUMBER])