Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How about this
Sum({$<[Clearing Document] = {''}, [CALENDAR_YEAR_MONTH_Posting_Date]>} If(Peildatum >= [Payment date], [Amount in local currency] * [Exchange rate]))
How about this
Sum({$<[Clearing Document] = {''}, [CALENDAR_YEAR_MONTH_Posting_Date]>} If(Peildatum >= [Payment date], [Amount in local currency] * [Exchange rate]))
Hi Sunny,
it works thank you. I had put the if statement at the wrong location.
BR
Hans