6 Replies Latest reply: Jun 11, 2016 9:21 PM by Shamit Shah RSS

    Label

    Shamit Shah

      Hi,

       

      I have the following expression and I want to the label it as Orders with the  Max Date

       

      Expression:

      count(Distinct{<PickDate={"$(=Max(PickDate))"},LIT_Status={'4'}>}PurchaseOrder)

       

      The Max(PickDate) would be the latest date e.g. 11 June 2016, hence the label should appear as "Orders 11 June 2016"

       

      Any ideas?

       

      Thanks

      Shamit