Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
calculating average in dataset
Migrateduser
Hey,
I want to find average in the dataset columns. Columns A,B are fetched from the database.
A B
1 5
2 10
2 5
3 20
4 10
5 15
Now i want to get average of column B for distinct values of column A. i.e result should be
A B C
1 5 5
2 10 7.5
2 5
3 20 20
4 10 10
5 15 15
Does anyone have any idea about this?
Thanks
Find more posts tagged with
Comments
There are no comments yet