13 Replies Latest reply on Feb 15, 2018 5:16 AM by Jim Dehner

    Sum of top clients

    harshitha k

      Hi all,

       

      I want to find the sum of the values of top 20 clients when aggregated on base number.

      WINDOW_SUM(IF [rank] = "Top 20 Clients" THEN SUM([aggregation on base_no]) END)

       

      The above calculated field gives me null as an output.null.PNG