7 Replies Latest reply: Aug 18, 2017 5:29 PM by Anand Chouhan RSS

    Need Help with Syntax

    saurabh sharma

      Hi,

      I have a problem in which I am trying to show the comparison between current month's total work hours logged by employee vs the last month. (I am using KPI for this purpose)

      My table has date as shown, all sequentially:

      img.JPG

      I basically want to sum the total hours for the last month and current month and show that as a KPI.

      I tried Sum( {“>=$(=Min(Date))<=$(=Max(Date))”} } EmpHrs) but its not giving any result.

      Any inputs shall be greatly appreciated.

      Thanks