Allow filters except the one used in aggregation

[#1]

Hello,

I am trying to accomplish following tasks on my data collection:

-Filter CreateDate By Today

-Ignore Any other filter on CreateDate

-Allow Any other filters to apply

-SUM(Quantity) for above

Ideally, intersection of following sets;

{$<CreateDate=>} --> Ignores Create Date filter, Yet allows other filters

{1<CreateDate={"$(=TODAY()"}>} --> Filters CreateDate by Today only

Not getting the results I need. Please advice.

[#2]

Hi,

Might be you need to have use DATE function.

1)  Can you debug the CreateDate and Today in list box, either both are matching or not.

2) CreateDate should not be string, if it is string you need to have convert itinto date.

Thanks

[sinanozdemir]

Hi,

The below expression should do what you are looking for:

Date is set to today's date and other filters can be applied to the table:

Hope this helps.

[MK_QSL]

=SUM({<Date = {"$(=Date(Today()))"}>}Quantity)

[#5]

This solution does not work for Filters on CreateDate. i.e. If I choose yesterday as a filter, the sum goes to 0.  I would like to

Ignore Any other date filter on the CreateDate Field. Any suggestions?

[MK_QSL]

=SUM({<Month=, Year=, Quarter=, Date = {"$(=Date(Today()))"}>}Quantity)

Same way you can ignore all other filters..

[#7]

Well, I actually don't want to ignore other filters. Only CreateDate Filter is what I want to ignore. e.g.

=SUM({<CreateDate=,CreateDate= {"$(=Date(Today()))"}>}Quantity)

which obviously doesn't work.

[MK_QSL]

Provide sample application. The one which I have given first is working for my application...

[#9]

Please read my original requirement. Your solution works partially. It does not satisfy requirement # 2

-Ignore Any other filter on CreateDate

Your solution below works when there is no filter on CreateDate.

=SUM({<CreateDate = {"$(=Date(Today()))"}>}Quantity)

If I choose CreateDate='1/1/2015', above total goes to 0, which is incorrect.

Hope this helps.

[MK_QSL]

Without checking your application, I can't help further. Sorry..

May be you can create a dummy application with sample data and attach here.