Hi Seeq,
One of my calculations in Seeq requires me to use SCALAR.INVALID.toSignal() and a long chain of splice() formula. For example:
SCALAR.INVALID.toSignal()
.splice(22.32.toSignal(),$a)
.splice(23.23.toSignal(),$b)
.splice(24.54.toSignal(),$c)
.splice(25.72.toSignal(),$d)
.splice(26.02.toSignal(),$e)
.splice(27.11.toSignal(),$f)
.splice(28.54.toSignal(),$g)
.splice(29.79.toSignal(),$h)
.splice(30.95.toSignal(),$i)
.splice(31.45.toSignal(),$j)
.splice(32.72.toSignal(),$k)
.splice(33.97.toSignal(),$l)
.splice(34.76.toSignal(),$m)
However, the calculation is not able to complete loading. Is there an alternative to replace SCALAR.INVALID? Any suggestions on how to improve this calculation?