Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is a conceptual question.
I have three fields SUBSCRIPTION START DATE and SUBSCRIPTION END DATE and SUBSCRIPTION AMOUNT
I want to be able to SUM the SUBSCRIPTION AMOUNT month by month to show churn.
My issue is that I cannot use the start or end date fields as my date column ... I feel like I need to make a new date. Also, I am not sure how to write the set analysis to evaluate between these two dates.
The set analysis below has worked for me, but I am not sure how to represent this OVER TIME that is now start or end date.
=sum({$< Won ={'1'},[Subscription End Date]={">=$(=Date(Today(),'MM/DD/YYYY'))"}>} [ARR-equivalent (converted)])
Any help is appreciated.
- dave
May be using While loop in script to create a date field from start and end date
Similar to Sunny's response.......