2 Replies Latest reply: Feb 26, 2018 8:35 AM by Hans kleijnen RSS

    input box in combination with set analyses

    Hans kleijnen

      Hi all,


      formula 1:  Sum({$<[Clearing Document]={''}, [CALENDAR_YEAR_MONTH_Posting_Date]>}[Amount in local currency]*[Exchange rate]) works and gives me all unpaid items.

      Formula 2: =if(Peildatum>=[Payment date], 'y','n'), works also. 'y' marked is overdue


      Peildatum is entered via an input box



      how can I best combine the two formulae so that the result is : unpaid and overdue


      thanks in advance