Reply
Mon 5 Apr, 2004 07:11 pm
Good day,
I have the following data sample:
Dates Risk Profits
16-Feb-04 Certain 0.0060
16-Feb-04 Uncertain 0.0060
16-Feb-04 Certain -0.0030
19-Feb-04 Certain 0.0060
20-Mar-04 Certain 0.0060
21-Mar-04 Certain -0.0040
22-Mar-04 Certain 0.0060
22-Mar-04 Certain 0.0060
22-Mar-04 Certain 0.0060
25-Mar-04 Certain -0.0040
08-Apr-04 Certain 0.0060
09-Apr-04 Certain -0.0040
1- I would like to be able to get the "Profits" average per month.
2- Also, per month, the number of rows where the value in the "Profits" column is >0
Many thanks in advance.
Regards.
Maxime
Profit is the third column.
Hi,
I might not have made obvious that the "Profits" column is the 3rd one.
The first column is the date, the second column, is called "Risk".
Thank you
Maxime
don't bother replying. I got the answer.
don't bother replying. I got the answer.
Glad you worked it out. Welcome to A2K anyway.
Stumble It!
Tweet This
Bookmark on Delicious
Share on Facebook
Share on MySpace