Increase % calculation

[ajsjoshua]

Dear All,

From the given data i want to calculate the patient increase % when the hospital gives discounts.

patientid	type	date	revenue	discount
1	Ip	2/3/2017	5000	250
2	Op	5/3/2017	4500	0
3	Op	18/4/2017	6000	0
4	Ip	23/4/2017	7000	350
5	Ip	1/5/2017	2000	0

Regards,

Joshua.

[Anil_Babu_Samineni]

What is the calculation would be to calculate the % in your business.

[ajsjoshua]

Dear Anil,

In the below data you can find the patientid 1 and 4 visited the hospital again because of discount which the hospital had given for their first visits.Now i want to calculate the patient increase % when there is discount.

patientid	type	date	revenue	discount
1	Op	2/3/2017	5000	250
2	Op	5/3/2017	4500	0
3	Op	18/4/2017	6000	0
4	Op	23/4/2017	7000	350
5	Op	1/5/2017	2000	0
1	Op	1/5/2017	3000	150
4	Op	2/5/2017	5000	250

[Anil_Babu_Samineni]

That means, You are going to execute each row which based on patientid if id already exists in each when this happened to next again