24 Replies Latest reply: Mar 16, 2018 4:08 AM by nagamani vadisala RSS

    count of  active months

    nagamani vadisala

      Hi,

       

      With below expression, we are able to get sum of value which we have in 18months. How can we get count of the months


      Sum({<Date = {"$(='>=' & Date(AddMonths(Max(Date), -24)) & '<=' & Date(AddMonths(Max(Date), -6)))"}>}Value)


      For example, i will be having data as 100 in last 12 months, this does not mean as in all last 12 months i have data.

      how can i get months and count of months in which i have data.


      Can anyone please suggest on this