Expression Help. Coalesce Null value

Ignition Early Access
1

Hey y’all

I have an expression:

substring({.../lotone/lot.props.text},0,9) + (toint(substring({.../lotone/lot.props.text},"10")) + toint(substring({.../lottwo/lot.props.text},"10")) +100+ toint(substring({.../lotthree/lot.props.text},"10")))

That works with all three properties great!

three
three838×221 8.75 KB

I got the count to work with two or three by coalesce.

two
the following:

toint({.../lotone/count.props.text}) + 
toint({.../lottwo/count.props.text}) + 
coalesce(toint({.../lotthree/count.props.text},0))

I need to do the same with the lots but can’t figure out how to call three functions: toInt the substring then coalesce or whatever. The function takes the digits after the 10th digit. and adds them up and adds an additional 100 and sticks that on to the first 9 digits and makes a new lot number. We know anything with a 1XX is a “merged lot”

I’ve tried several different ways

substring({.../lotone/lot.props.text},0,9) + (toint(substring({.../lotone/lot.props.text},"10")) + toint(substring({.../lottwo/lot.props.text},"10")) +100+ coalesce(toint(substring({.../lotthree/lot.props.text},"10"))))

I guess the broader question is can and if so how do you setup args for nested functions. I’ve had my nose in docs but no such luck… Thanks as always!

2 
substring({.../lotone/lot.props.text},0,9) +
(toint(substring({.../lotone/lot.props.text},"10")) + 
toint(substring({.../lottwo/lot.props.text},"10")) +100 + try(toint(substring({.../lotthree/lot.props.text},"10")),-1))