8 Replies Latest reply on Jul 12, 2018 11:18 AM by Hamza Alsalman

    finding max 3

    Hamza Alsalman

      Hello I have a question about find max 3 customers.

       

      I have this formula: RUNNING_SUM(IF [open_dt]>=([max date]-59) then [Curr Bal Amt] END)

       

      I want to calculate a sum of balances over the past 60 days by (prod dt)<---this is my field for every day I have data

      I also have another field called open dt which tells me if an account was opened.

      I would like to calculate total [curr bal amt] if the acct was opened in the last 60 days and only show the top 3 customers with the highest balance.

       

      Unfortunately I cannot offer any sample data as it is all sensitive data. Thank you!