Skip to Content

Grouping values using reportFilter with IF clause

Nov 08, 2017 at 04:25 PM


avatar image
Former Member

Hi, guys!

I have a var like this: [yearFilter] = "2017"

and when i use this:

=If [Year] = [yearFilter] Then [Year] Else "0"

This works well. all rows are grouped between "2017" and "0"

But if i change the var like this: [yearFilter] = ReportFilter([Ano]), my rows do not grouping. I have multiples rows with "0" values.

What is wrong?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers