3 Replies Latest reply on Jan 17, 2019 3:08 AM by Mahfooj Khan

    Calcultate PnL between two date with the Date in Filtre choice

    Thomas MICHEZ

      Hi,

       

      I need help for a calculation field please !

       

      Here is my table o nthe database :

       

      DatePnL
      01/01/20191,05
      02/01/20192,1
      03/01/20191,7
      04/01/20191,7
      05/01/20191,8
      06/01/2019

      1,9

       

      I need a graphic to calculate PnL between two date ("Diff PnL" on my below table). As the date will be in the filter.

      I need you to calcul the two column : PnL at Date Min & PnL at Date Max

       

      If the guy filter Date between : 02/01/2019 to 05/01/2019

       

            

      Date MinDate MaxPnL at Date MinPnL at Date MaxDiff PnL
      DatePnLWINDOW_MAX(min([Date]))WINDOW_MAX(MAX([Date]))??????PnL Date Max - PnL Date Min
      01/01/20191,0502/01/201905/01/20192,11,8-0,3
      02/01/20192,102/01/201905/01/20192,11,8-0,3
      03/01/20191,702/01/201905/01/20192,11,8-0,3
      04/01/20191,702/01/201905/01/20192,11,8-0,3
      05/01/20191,802/01/201905/01/20192,11,8-0,3
      06/01/20191,902/01/201905/01/20192,11,8-0,3

       

      Thanks for your help.

       

      Thomas.