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 an average of a table column and using it in a new calculated column of the same table
Migrateduser
<p>Hello,</p>
<p> </p>
<p>I have a table with measurements in one column. Now I want to normalize these measurements. Means calculating the average of these measurements and then create a new column which contains a measurement minus the calculated average.</p>
<p> </p>
<p>My approach was using a page variable.</p>
<p>I managed to create a new column in the table which takes the measurement value and subtracts the page variable.</p>
<p>But I'm having trouble assigning the page variable the average value of the measurement column.</p>
<p> </p>
<p>Any ideas on this one?</p>
<p> </p>
<p>Thanks</p>
<p> </p>
<p>Gerrit</p>
Find more posts tagged with
Comments
There are no comments yet