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?
Something like:
Count( {<[TRACK NUMBER]={"=Len(Trim([TRACK NUMBER]))>0"}>}[TRACK NUMBER])