3 Replies Latest reply: Nov 23, 2015 2:30 AM by balraj ahlawat RSS

    Order_Date=max(Order_Date) gives an error in formula

    Mahm Tamal

      Hi All,

       

      I'm trying to write a conditional sum function.

       

      When I write it like this, it works.

       

      sum(if(Order_Date='18/11/2015',Order_Qty)

       

      But if I want to make the chosen date dynamic as the most recent date in the table, where I'm using max(Order_Date), it gives an error:

       

      Error in Expression

      sum(if(Order_Date=max(Order_Date),Order_Qty)

       

      Any idea how to fix this?

       

      thanks..