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

[Anonymous]

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

[v-deddai1-msft]

Hi @Anonymous,

Would you please show me more information about how to calculate revenue in your sample. I don't have much knowledge about it.

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

[Anonymous]

@v-deddai1-msft 

Its (Qty * rate) per month

[v-deddai1-msft]

Hi @Anonymous ,

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

Best Regards,

Dedmon Dai

[Anonymous]

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

[Anonymous]

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