Trying to get a saved search to return possible du...
# suitescriptt
toltmanns
12/15/2021, 6:46 PMTrying to get a saved search to return possible duplicate transactions based on the vendor and amount, however we're unable to group on the amount, and doesn't seem possible to convert that amount to text for subsequent grouping
b
battk
12/15/2021, 9:57 PMusually you can use a formula if you need to get around this, text formulas are usually groupable
t
toltmanns
12/15/2021, 10:37 PMyeah I tried that though without success
toltmanns
12/15/2021, 10:37 PMformula text
toltmanns
12/15/2021, 10:37 PMTO_CHAR({amount})
toltmanns
12/15/2021, 10:38 PMgive me invalid expression
b
battk
12/15/2021, 10:39 PMthat probably should work
battk
12/15/2021, 10:40 PMbut you can be lazier and just do {amount}
t
toltmanns
12/15/2021, 10:41 PMThe result field Formula (Text) cannot be grouped. Please edit the search and omit this field or use a different summary function.
b
battk
12/15/2021, 11:14 PMprobably have to find a different grouping then
21 Views