10 Replies Latest reply: Jun 28, 2017 3:53 AM by Gabriele Formici RSS

    getfieldselections with multiple values

    Gabriele Formici

      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.