Min max date based on product usage.

[#1]

Hello there folks,

First and foremost, couldn't think of a suitable title for the discussion - am going to try my best to explain the situation in detailed.

Planning on developing a report for a subscription based service. Trying to find out a way to compute/script - usage of the service by customers based on the (no. of days). The script would look something like this:-

Based on (customer) {

     Max(usage date) - Min(usage date) = no. of days using the service

}

Please advise. Thanks.

Best Regards,

R

[#2]

Hi Ram,

Here's one option for calculating retention in your script. If this doesn't work, try attaching a sample or explain your data structure in more detail.

Let me know if you have any questions.

Best,

Matt

[#3]

Hi Matt,

Thanks for the quick reply. Will test it out and let ya know. Cheers.

Best Regards,

R