Cumulatively Sum Cells in Dissolution Report in Empower
Posted: Tue Aug 30, 2011 9:04 pm
Hi:
We have a dissolution test where there are 6 collections, Hours 1 through 6.
We have been using Excel to do the calculations, but now I want everything done by Empower.
In Excel, there are 2 Columns, Amount and Cumulative Amount. The Amount column has each collection amount in ug/mL. The Cumulative Amount has the total Amout collected at each collection point (Hour 1 amount, Hour 1 & Hour 2 Amounts, etc.). Easy enough.
How can this be duplicated in Empower? I've used Intersample Calc, but so far have only been able to return a total amount, not Hr1, Hr1 + Hr2...Sum of Hrs 1 - 6.
What I want is something like this:
Cumulative
AMOUNT Amount
8.5123 8.5123
3.7493 12.2616
4.7189 16.9805
3.3629 20.3434
2.8510 23.1944
2.3628 25.5572
What I have now:
Cumulative
AMOUNT Amount
8.5123 25.5572
3.7493 25.5572
4.7189 25.5572
3.3629 25.5572
2.8510 25.5572
2.3628 25.5572
Thanks,
Mike
We have a dissolution test where there are 6 collections, Hours 1 through 6.
We have been using Excel to do the calculations, but now I want everything done by Empower.
In Excel, there are 2 Columns, Amount and Cumulative Amount. The Amount column has each collection amount in ug/mL. The Cumulative Amount has the total Amout collected at each collection point (Hour 1 amount, Hour 1 & Hour 2 Amounts, etc.). Easy enough.
How can this be duplicated in Empower? I've used Intersample Calc, but so far have only been able to return a total amount, not Hr1, Hr1 + Hr2...Sum of Hrs 1 - 6.
What I want is something like this:
Cumulative
AMOUNT Amount
8.5123 8.5123
3.7493 12.2616
4.7189 16.9805
3.3629 20.3434
2.8510 23.1944
2.3628 25.5572
What I have now:
Cumulative
AMOUNT Amount
8.5123 25.5572
3.7493 25.5572
4.7189 25.5572
3.3629 25.5572
2.8510 25.5572
2.3628 25.5572
Thanks,
Mike