getfieldselections with multiple values

[#1]

Hi everyone.

I'm currently trying to use the function getfield slections in order to filter a table based on a selected value in a filter box.

The expression I'm currently using is the following:

=sum(if(recorddate=getfieldselections(selecteddate), revenues))

The problem arises when I select two or more date in the filter box: the if function finds no corresponding value.

How can I deal with this issue? Thanks.

Please see attachments for further details.

Additional info: selectedddate and recorddate are not linked together - there's no association between them.

[#2]

Great! Funny thing is that I've always used Sum(if(..)) function and I was wondering why this time didn't work.

As you mentioned, one of the two date was loaded as text, not as a date itself.

Thanks for your help.