3 Replies Latest reply on Apr 30, 2017 3:34 AM by Julia Balkheimer

    Get last date and corresponding value

    Julia Balkheimer

      Hi everyone,

       

      I am able to get th elast day from different dates, however I have issues of receiving the value of another variable for the last date.

       

      I am calculating the last date this way:

      Latest date:

      TOTAL(MAX([Col34]))

       

       

      As a last step I would like  to get the value of the KPI in "col35" for the last day

      LOOKUP(WINDOW_SUM(sum(IIF([Latest Date],[Col35],0))),0)

      Can you please advise why I get the an aggregation error?

       

      I would like to the same for YTD and MTD.

      How do I calculate YTD, MTD?

       

      Thanks

      Julia