FYi.. that last formula you sent has an extra pare...
# suitescript
e
FYi.. that last formula you sent has an extra parenthesis (the first one isn't needed).. removing that makes it work.. still not sure if its what you are looking for as i haven't read through all these messages