September 21, 2009 at 4:16 am
Hi
Apart from my language issue I have another problem concerning filtering on a group.
I have a table with a group and to display the number of detail records for each group, I typed "=SUM(1)" in a column at the same level of the Group.
This works fine and tell me how many records I will get once I expand my group. So far so good.
Now I would like to display only the Groups which have more than 10 retail records.
I have added a filter on my group like so:
Expression: =SUM(1)
Operator: >
Value: 10
I get the following error:
The processing of FilterExpression for the table "table1" cannot be performed. Cannot compare dataof types System.Double and System.String. Please check the data type returned by the FilterExpression.
I have tried the following but get the same error:
=IIF (SUM(1) > 10, True, False)
=
=True
Can someone points to me where I'm going stupid?
Cheers
Ludo
September 21, 2009 at 5:32 am
Sorry to reply to my own post but this has now been sorted out.
I am ashame to admit that there was still a badly formed filter in another table which was generating the error.
Now I have used "=CountRows()" ">" "=50"
This filters out all the groups which contain less than 50 detail records.
Cheers
Ludo
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply