nibor100
1,031 posts
msg #151726
- Ignore nibor100 |
4/5/2020 9:20:23 AM
Seems like it parses past the variable "hi" if the abs command uses "-" instead of "minus"
Ed S.
|
JoeyVinyl
125 posts
msg #151738
- Ignore JoeyVinyl |
4/5/2020 3:59:22 PM
That is weird. I played around with it, changing the variable names just to see if that made any difference but it didn't (just adding 52 in front). I also added just a 'hi - lo' column to see the actual difference. I found just what you found with the abs function. When I used the "-" symbol it always gave the low number, but when I spelled out "minus" it gave the actual difference.
Maybe someone from the SF team can tell us why.
|
nibor100
1,031 posts
msg #151740
- Ignore nibor100 |
4/5/2020 4:21:46 PM
Thanks for looking into it.
I wasn't going to send a question to SF because usually when I send a "why" question they don't answer it directly; but simply send me back the part of the filter that actually works...like I didn't already have that part figured out.
Generally, it seems that words in SF filters have more capability in certain situations than arithmetic symbols.
Ed S.
|