3 Replies Latest reply: Feb 21, 2017 11:16 AM by Rupam Das RSS

    (min) function in set analysis

    Глеб Aitov

      Hi!

       

      I have dates and revenues for each date, DATE and REVENUE fields

      When the user selects the range of DATE, I want to calculate sum of REVENUES for the minimum date in the selected range.

       

      The formula does not work, why? I tried different ways and still don't get anything, unless I put the fixed date inside. Thank you!

       

      Sum({<[DATE]={min(DATE)}>} [Revenue] )


      Sum({<[DATE]={=min(DATE)}>} [Revenue] )