cancel
Showing results for
Did you mean:
Frequent Visitor

## How do I get Mly, Qly, Hly, Yly revenue in this case?

Hi Guys,

I need to calculate the revenue from below format data, I have plan start date and end date is always 31/12/9999, by requirement is if a customer started on Jan 1st, record shows as 1/1/2021 to 31/12/999 with quntity and rate, I need calculate Mly, Qly, Hly, Yly revenue. Below is the screen shot.

Let me know if I can get this revenue.

Regards

Phaneendra

5 REPLIES 5
Community Support

Hi @Phaneendra,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

Frequent Visitor

Its (Qty * rate) per month

Community Support

Hi @Phaneendra ,

How do calculate monthly qtrly yearly revenue? (Qty * rate) /12?

Best Regards,

Dedmon Dai

Frequent Visitor

so, let me give you a simple example for understanding.

eg: we have 3 clients who pay 25\$ per month and C1 started on 1/1/2021, C2 started on 1/2/2021 and c3 started on 1/3/2021.

in this case on 31/3/2021 my reveune will be 75+50+25 = 150

and in Q2 it will be 25*3(clients)*3(months) = 225

and if the user selects half then it will be 150+225 = 375

in simillarly Yly and Mly, Prev ylr or in selected time period.

Regards

Frequent Visitor

I have a data range too, as per selected data range I need revenue.

Announcements

#### Launching new user group features

Learn how to create your own user groups today!