anyway this bin on hand amount to show up on a sav...
# generalo
Ogabeg
11/13/2020, 6:01 PManyway this bin on hand amount to show up on a saved search - currently it shows as 0.0
k
Karina
11/13/2020, 6:31 PMuse TO_CHAR formula to expose all digits
o
Ogabeg
11/13/2020, 6:34 PMIm having trouble with the syntax...
Im trying to do this for the join field Bin On Hand : On Hand
TO_CHAR({binonhand.quantityonhand} [, fmt [, 'nlsparam' ] ])
keep getting errors
k
Karina
11/13/2020, 6:43 PMtry TO_CHAR({binonhand.quantityonhand} ,‘999.9999999999999’)
o
Ogabeg
11/13/2020, 6:52 PMgot this error- ERROR: Invalid Expression
k
Karina
11/13/2020, 6:55 PMTO_CHAR({binonhand.quantityonhand},‘ 999.9999999999999’)
Karina
11/13/2020, 6:55 PMops
Karina
11/13/2020, 6:55 PMit should be a space between coma and '
Karina
11/13/2020, 6:56 PMand no space between ' and 9
o
Ogabeg
11/13/2020, 6:58 PMstil getting the same error
e
ericbirdsall
11/13/2020, 8:49 PMNot sure if you tried copying a pasting Karina’s comment, but make sure you’re using single quotes and not the curved quotes that show when trying to type a single quote on a Mac
' is not the same as ‘
ericbirdsall
11/13/2020, 8:50 PMTO_CHAR({binonhand.quantityonhand}, '999.9999999999999')ericbirdsall
11/13/2020, 8:50 PM^I can’t confirm whether this is correct or not… I just saw the curved quotes and know NetSuite will throw an error if they are in a formula