Error 'sqlPrepareWithOptions' status='-9' when I insert data item.

[svj]

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!

[Lynn]

I don't think you need the sum function. Try removing it and then setting the aggregate property for the data item to total.