Spotfire IF Statement in Custom Expression

问题:

If(Len([THROUGHPUT_SPEC]> 0),[THROUGHPUT_SPEC],[SUB_TYPE])

When I tried above formula I receive an error

'>' as invalid operator

Could someone help in fixing this.

回答1:

Try this

If(Len([THROUGHPUT_SPEC]) > 0,[THROUGHPUT_SPEC],[SUB_TYPE])

You omitted the closing bracket in Len([THROUGHPUT_SPEC])