0 Replies Latest reply on Aug 19, 2015 3:39 PM by 2880878

    Count a column value with condition in RTF Template

    2880878

      Hello All,

       

      On RTF template, I have a column called "Days Pending". Days Pending can have any values from 10 to over a 100. I have another column called "Between 46 and 59 days".

       

      For the second column, I need to write a formula that is similar to count(days_pending) when days_pending between 46 and 59. In other words, I need to count how many values of "Days Pending" column fall between 46 and 59 days. How can I do this on a RTF Template?

       

      Any help is appreciated.

       

      Thanks