Date wise average base on ID

[iahmadmca1]

Team,

Just want to ask one requirement based on date wise average.we have date column AM and PM I want to average of 11/21/2016 AM and 11/21/2017 PM.

Let's consider 11/21/2016 AM as (A) and 11/21/2017 as (B).I want to average each every day based on AMITGBID.could you please help me to do this.As for example

1.avg=(B-A/A). I want to calculate the average based on AMITGBID

Thanks,

Irshad Ahmad

[Anil_Babu_Samineni]

I am not following you, You mentioned A & B and then Avg of A-B. Till this is okay for me. What are the dates you have. Would you share sample to work on it and try to explain expected result also

[iahmadmca1]

Thank for the response Anil, Write now I have only  11/21/2016 AM and 11/21/2017 PM. Based on this date I want to calculate the average.

The expected result will be.

A=30518 and B=28484 and AMITGBID=1922 then.

avgresult=28484-30518/30518;

Thanks,

Irshad Ahmad

[Anil_Babu_Samineni]

A=30518 and B=28484 and AMITGBID=1922 then.

How you are getting these values, That is my question? There is no data points available

[iahmadmca1]

I request to you please refer the article which is uploaded.

let's see once again.

AMITGB ID      11/21/2016 AM    11/21/2017 PM

-----------------------------------------------------------------------

1922                      30518                     28484

3765                      26083                     25642

1807                      18996                     19939

Like this, i have data set.