Page 1 of 1
The SAME comand in EMPOWER programing??
Posted: Thu Mar 25, 2010 8:13 am
by johan.gustafsson
Hello everybody,
Is there anybody that can explain the SAME comands function in EMPOWER programing. It is not described in the help files.
Regards / Johan
Posted: Thu Mar 25, 2010 1:35 pm
by DR
best guess given way too little information: It has something to do with an intersample calculation someone has dropped in among your project's custom fields, or someone has named a custom field "SAME".
Posted: Fri Mar 26, 2010 3:24 pm
by Dividination
I'm not familiar with any function called SAME. Is it a custom field? If so I'm guessing it's a just a reference to another custom field result named SAME. Take a look in the custom field list for the project. Not there? Was it copied from another project? May be there.
SAME function = good for you
Posted: Fri Apr 09, 2010 2:06 pm
by EmpowerGuru
SAME is used in intersample calculations. For example
SAME.%.%.AVE(Area) will give you the average area for all injections with the same label.
Another good way of using SAME is
Area- SAME.%.%.Area
This will give you the area minus the area of the previous injection. This works great because you can have the same label for every injection in the sample set. You do not have to use variables for example S* type trash is not necesarry. This works great for duplicate injection percent difference. Also, the analyst has nothing to enter in the sample set to make it work.
Posted: Fri Jun 18, 2010 9:08 am
by Legacy_SP
Area - SAME.%.%.Area doesn't seem to work for me.
The error message shows 'Cannot use a comma here. It is only allow ENUM, LT, GT, LTE, GTE, EQ, NEQ, or RANGE function.'
Anything that I have keyed in wrong?
I have to create a custom field to calculate % Variation of Assay between two preparations. I have multiple samples in the sampleset.
My formula:
(Amount-SAME.%.%.Amount)/SAME.%.%.Sum(Amount)*100
Posted: Tue Jun 22, 2010 10:07 am
by benW
Hi Legacy_SP
The problem you have seen is in the syntax
My formula:
(Amount-SAME.%.%.Amount)/SAME.%.%.Sum(Amount)*100
For the syntax:
1) You need to specify that Amount is a field by using brackets rather than the point (or period)
2) The SUM is a summary function and needs to be in capitals:
(Amount-SAME.%.%
(Amount))/SAME.%.%.
SUM(Amount)*100
This is not necessarily the best way to do this, and may not work in Empower 2154. This is because the summarize custom field function was corrected in Empower 2154 and does no work quite the same as it did in Empower 1154 (Empower). In 1154, the summary function was calculated incrementally and your custom field may work. But in Empower 2154, the summary custom fields (such as this) will be summarised at the end. This may work again in Empower 2 FR5 with an incremental choice with the summary function.
Posted: Wed Jun 23, 2010 8:40 am
by Legacy_SP
Hi benW,
Thanks for the suggestion. I think I made a mistake in using the formula. The previous formula doesn't work for my need.
My new customfield formula is
ABS(((2*Amt_100-SAME.%.%.SUM(Amt_100))/SAME.%.%.SUM(Amt_100))*100)
As my company will upgrade from Empower 1154 to Empower 2 soon, will the above customfield work in Empower 2?
Posted: Wed Jun 23, 2010 3:24 pm
by DR
It should work.
You know, Empower 3 is due out any time now (if it is not already out)...
Posted: Thu Jun 24, 2010 5:32 am
by Legacy_SP
Too bad, its a corporate decision to go Empower 2.
Posted: Thu Jun 24, 2010 6:20 pm
by benW
Not a bad decision.
As well as the general improvements to the software and the extended support life, there are a few neat extra features in Empower 2 over Empower.
I agree that your custom field should work without a problem, as it does not use both an incremental SAME value and a Summary function SAME value.
Have fun with the upgrade...