5 Replies Latest reply: Sep 25, 2018 2:35 PM by Shahbaz Khan Mohammed RSS

    Report Current Quarter Values

    Thomas Williams

      Hi,

       

      I have a dial that currently reports current month. How do I amend my logic to report current quarter values please?

       

      I have tried the logic below but doesn't seem to provide any values when I know it should.

       

      Sum({<DATE_IN = {">=$(=Date(QuarterStart(Max(DATE_IN), -1)))<=$(=Date(Max(DATE_IN)))"},

      Team_Name = {'MenF'},Contract_Type ={'Upl'},

      [Country] = {'UK'}>} Total_Contract_Val_new)