6 Replies Latest reply on Apr 24, 2019 6:03 PM by Michael Scappator

    Calculation the last business day with exclude from Saturdays and Sundays

    Lea Zimmer

      Hello together,


      I am planning to show the profit from the last business day.


      My first step was to exclude Saturdays and Sundays as possible dates for the cancellation dates.


      DATEPART('weekday',[Datbuch]) <> 1 AND DATEPART('weekday',[Datbuch]) <> 7


      DATEPART('weekday',[Datstorno]) <> 1 AND DATEPART('weekday',[Datstorno]) <> 7


      In the next step I want to include this integration into my calculation as well as starting with the last business day instead of the present day.


      ZN(IF [DATEPART('weekday',[Datbuch]) <> 1 AND DATEPART('weekday',[Datbuch]) <> 7]

      AND [ART]="D"

      THEN [Nw1Gesnettoprofit]



      Thank you