Join Slack
Powered by
Is it possible to do a formula (text) with a group...
# suiteanalytics
j
jonny
12/01/2020, 3:27 PM
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.
Open in Slack
Previous
Next