14 Replies Latest reply: Jul 21, 2016 12:46 AM by Ramkumar Ramagopalan RSS

    Sum of value for min date

    Alec Harf



      on a table I have Date Column and then a value column and also a column with flag


      on a table chart, I want to have Date, Min Date, Sum values, Value on Min Date.


      I used


      Sum(if(Flag = 1 and [Date]= Min(Total <[Date]> [Date]),[Value])) to show value of the minimum date but getting null.


      Anyone can help.