1 Reply Latest reply: Jan 4, 2018 12:41 AM by P M RSS

    Display Latest Quarter in KPI

    Monu Saraswati

      Hi ,

       

      I want the latest Quarter to be display in the KPI object.

      Example - "Q1-2018" . Quarter Column is coming from the table. Please let me know what function can be used to get the latest quarter value in the KPI object.

       

      Thanks

        • Re: Display Latest Quarter in KPI
          P M

          Try this

           

          SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))}

          ,[Posting Date]={">=$(=QuarterStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date])))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}

          >}[Sales Amount])

           

          or

          (SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))}

          ,[Posting Date]={">=$(=QuarterStart(max([Posting Date])))<=$(=max([Posting Date]))"}

          >}[Sales Amount])