Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Zero in a saved search drops off in the results
Hi There
I have two saved search questions:
- Why does the leading zero drop off a value if the result is less than $1.002.222
The formula behind the 'running total'(text) column:
TO_CHAR((SUM /*Balance*/(CASE WHEN {type}= 'Credit Memo' THEN {fxamountremaining}*-1 WHEN {type}='Payment' then {fxamountremaining}*-1 else {fxamountremaining} end) OVER (ORDER BY {trandate} ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)),'9,999,999.99')
Since this is a text value, I would expect this to take any amount value as is and return this as a string (without rounding)
2 Why is there no currency symbol on the amount remaining column if the value is converted to a negative?
Tagged:
0