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.




      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



      Any idea how to fix this?