9 Replies Latest reply: May 5, 2014 4:42 PM by Dariusz Mielczarek RSS

    Set analysis - count values for latest possible date

      Hi everyone,

       

      I am working on the project tracker and updating status of individual projects through collection of XLS detaileded workplans. Not every project will be updated reguarly. I created signle table to summarize the latest status of all initiatives using FirstSortedValue(Task, - Date). Now I am having difficulties to write set analysis formula to count tasks by status for latest date within Task where version = 'Actual'.

      28-04-2014 12-47-31.jpg

       

       

      Could you please help?