I'm trying to show this as a grouped row. Anyone seeing something wrong? It's keep saying ERROR: Invalid Expression
Formula - Text , Group
I'm trying to show a grouped row using the following formula-text.
Other results will be grouped so I need to group this, it keep showing me an error: invalid expression. What am I doing wrong?
Formula(Text) - Group
CASE WHEN COUNT ( {line} ) = SUM ( CASE WHEN {applyingtransaction} like 'Item Fulfillment%' THEN 1 ELSE 0 END) THEN "OK" ELSE "CHECK" END