Is it possible to do a formula (text) with a group...
# suiteanalytics
j
Is it possible to do a formula (text) with a group summary type when you have an amount field in the formula? This formula on a transaction search
CASE WHEN {amount} > 100 THEN 'A' ELSE 'B' END
throws an error saying that the column cannot be grouped even though the result is clearly text.