SELECT has invalid inputs

[BOTFORCE]

Dear friends,

I have this expression in a virtual column with datatype NUMBER, and cannot find the error. Anybody who can help out? Thx.

if(
[Navigation Name] = "1 - Neu erfasste Behandlungen",
count(
SELECT( Behandlung[BehandlungsID],
AND(
ISBLANK([Unterschrift]),
ISBLANK([UnterschriftDr.]),
[BehandlungDurchgefuehrt] = false,
ISBLANK([BehandlungAbgelehnt]),
[TerminStoniert] <> true
),0
)
), 0
)

[Suvrutt_Gurjar · Accepted solution]

Perhaps you are looking for this?

if(
[Navigation Name] = "1 - Neu erfasste Behandlungen",
count(
SELECT( Behandlung[BehandlungsID],
AND(
ISBLANK([Unterschrift]),
ISBLANK([UnterschriftDr.]),
[BehandlungDurchgefuehrt] = false,
ISBLANK([BehandlungAbgelehnt]),
[TerminStoniert] <> true
)
)
), 0
)

[BOTFORCE]

Thx friend! OK, my mistake:-)

[Suvrutt_Gurjar]

You are welcome. No problem,  we all sometimes err.