Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
