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

    Sum of value for min date

    Alec Harf

      hi,

       

      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.

       

      Thanks