I tried using this code to put parentheses around negative values of the variable lvTot5 :
lvTot5 = ?(lvTot5<0,pattern(-lvTot5,"($#,)"), lvTot5>0,pattern(lvTot5,"$#,"),"")
but negative numbers lose the trailing parenthesis. I was forced to use this code:
lvTot5 = ?(lvTot5<0,pattern(-lvTot5,"($#,") + ")", lvTot5>0,pattern(lvTot5,"$#,"),"")
Can anybody replicate this problem?
admin
June 8, 2019, 8:05am
2
Looks like a bug to me. I’ve added a bug report.
You are supposed to be able to use a pattern like
pattern\(x,”\(#,.##\)”
```
pattern(x,"(#,.##)")
```
to display negative numbers with \( and \) around the number, for example -12.34 would display as \(12.34\), while 4.56 would display as 4.56....
Also, off topic, but man to I hate the buggy new text editor in BitBucket.
admin
March 14, 2020, 9:11am
3
I went to fix this bug and now I cannot duplicate it. It works fine for me on both my development version and on the official Panorama X 10.1.2 release. Not sure why I didn’t think it worked back in June.