Empower 3 custom fields

[nattasha]

Hello
I’m wondering if someone can tell me how to write a custom field (the format, what type of parenthesis, etc) if I want to pull a value from a standard sample type into a result custom field.
I already have the following custom field for my result calculation:

Percent_AA = ((Amount*Pstd*0.1*20)/(500*Wsmp*0.1)*100)
Currently, I am putting in the actual value of Pstd for all samples in alter sample. I would like to be able to enter this value for the standards, not the samples.

How do I do this and enter it in my Percent_AA result custom field? In other words, how do I tell Empower to pull the value from my standard rows in alter sample, not the sample rows? My working std and check std are labeled as "control" for sample type. My bracketing standards are labeled as "standard" for sample type.

Thank you for any help in advance!

[shaun78]

If I understand what you are after ...

All you need to do is create a component type custom field called Pstd. The data type will be Real (0.0) and the source will be keyboard. This will give you a purity cell/tab when you click the amounts button in the sample set method editor. Only enter the purity value for the standards.

I *think* this should accomplish what you are after.

[nattasha]

Hello
Yes, that worked. I got it to show up in the components window, but how do I write the formula so it pulls my Pstd value from the components? My result formula is: Percent_AA = ((Amount*Pstd*0.1*20)/(500*Wsmp*0.1)*100)

Do I leave the Pstd in there as is? It doesn’t seem to be giving me a result after I enter a value into the components window.

Thank you

[shaun78]

Yes, you should just leave the Pstd in you formula if that is what you named the custom field you created.

Not getting a result was what I was worried about. A few years ago I had to create a label claim field only to be used on samples and one that would be a different value depending upon the analyte.

Anyway, I believe you are going to need to enter a value of "1" for all of your samples in order to get the calculation to work. Empower is finding a blank cell for the Pstd and can't complete the calculation.

[nattasha]

Thanks for all the help!