I have two data items :
1)
sum(If ([DEV].[STATUS] IN ('Success','Failure'))
THEN ([DEV.[AMT])
ELSE (0))
2)
sum(If ([DEV].[STATUS] IN ('Success','Failure'))
THEN (1)
ELSE (0))
When I try to use the first item in a list cell I get an error 'sqlPrepareWithOptions' status='-9' / group function is not allowed here
Thanks!
I don't think you need the sum function. Try removing it and then setting the aggregate property for the data item to total.