Ignore filter that has conditions

[AlexWest]

Hi, guys!

I have the following expression in my chart:

sum(
{$<
BUSINESS_TYPE = ,
[ACT_DATE] = ,
[ACT_DATE.autoCalendar.Date] = ,
[ACT_DATE.autoCalendar.Month] = ,
[ACT_DATE.autoCalendar.Year] =
>}
AMOUNT_IN)

Which ignores all described filters and never doesn't stop SUM an AMOUNT.

BUT! I have a filter with the next expression:

=if([ACT_DATE.autoCalendar.Date] = date(Today()-1), [ACT_DATE.autoCalendar.Date])

And when I try to add the expression to that sum above, my chart doesn't ignore it, and making change((

Is there any idea what should I do to make the chart ignore this filter? Like it works with naked filters?

Thanks!

[BrunPierre]

Hi , Try with this

Sum(
{$<
[ACT_DATE.autoCalendar.Date]={'$(=Date(Today()-1))'}
BUSINESS_TYPE = ,
[ACT_DATE] = ,
[ACT_DATE.autoCalendar.Date] = ,
[ACT_DATE.autoCalendar.Month] = ,
[ACT_DATE.autoCalendar.Year] =
>}
AMOUNT_IN)

[AlexWest · Accepted solution]

Hi!

Nope, it doesn't work for me.

I went another way:

I just made a field in Script: 

if(date([ACT_DATE]) = date(Today()-1), date([ACT_DATE])) as YESTERDAY_DATE

And now I use a field YESTERDAY_DATE in a Filter Chart 🙂