Empower help , Amount/dose query

[ydna6969]

Hi ,

Empower ,again
Im trying to calculate :
Total sum amount/dose in empower

How would this be done ?
I know you can have the sum in report table using summary function nut how do you get this number further results . Do i require custom fields
ie , I require Sum (amount 1 amount 2 aomunt 3..... amount /dose (think this will be integer custom field)

Any help much appreciated

[ydna6969]

sorry ,

also how would you truncate the sum value ?
I have the formula for truncation but I just cannot see how to sum amounts required for further manipulation

A

[ydna6969]

hi

also ,,, , anybody figured out how to do dissolution mass and volume correction in Empower?
Other CDS's I have used in the past seemed to manage this with abit of manipulation of volume corrected results but I dont know where to start with Empower ?!

help much appreciated

A

[DR]

partial answer to your myriad questions:

truncation: for every field, you can set properties, including precision. Things are rounded correctly according to the precision set. Truncation is possible, but not generally recommended as further calculations based on truncated results will likely suffer.

Dissolution: Have you purchased the dissolution option? It is the best way to go, in my opinion - especially for GMP applications. The common alternative is to export areas and calculate in Excel, taking the differences in volume into account there. If you validate and lock down a spreadsheet that can take information from a locked down Empower export method, great. If not, you will have to spend lots of time verifying calculations.

[ydna6969]

We require truncation as requested by out of house specifications
I have custom field for truncating amounts.

Im struggling to see how you can manipulate the sum totals
Any ideas pleas let me know

[aceto_81]

How about putting a dose integer field as a sample field.
Then make a customfield with amount/dose

And use your table summary SUM function to sum them up, rounded to a specified decimal?

Ace

[ydna6969]

I see what you are saying aceto_18

But i need to use this sum of amounts for other calculations

I just need to be able to calculate sum amounts (as carried out in component table summary)

Any ideas

ie

amount /cap (calc in epmower)
2.5
2.4
2.3
2.2
2.1

sum = 11.5 (how to calcualte this as a custom field)

thanks

[ydna6969]

Maybe I have confused issue here
What I require is to truncate the sum of amounts (truncation part of our reports/spec so is required)

example:

total sum ug (using component summary in report) = 458.589
I need to truncate this value to 2dp so would = 458.58 ,how do I achieve this

I have custom field for truncating other values but will not work for SUM as error :
'Only Distribution, Chrom,Injection and Vial fieldscan be used with SUM,MIN,MAX or AVE when creating a PEAK custom field.'

Any ideas much appreciated

[ydna6969]

Hi ,

Think I've managged to figure this out

By using custom field B.%..sum(Amount) for all samples labelled 'B' (1st 10 samples)
Then using truncation custom field for this custom field
Although in typical sequence I have to sum samples 4*10 sum amounts ,so will need more custom fields
ie C.%..sum(amount),D.%..sum(amount),E.%..sum(amount),,ETC, not ideal

Any further ideas please let me know