How create the custom fields formula ?

Options
2»

Answers

  • Empower2019
    Empower2019
    Options

    Thanks. For the first part of your formula, create a peak, real custom field, search order result set only. Label Std1 as S1 and Std 2 as S2. The formula is (S1.%..AVE(Area)/S2.%..AVE(Area)). Call this CF CF_1.

    The second half of your formula, I advise putting the sampleweight of Std1 into CConst1 of your processing method and put the sampleweight of Std2 into CConst2 of your processing method . Make sure CConst1 and CConst2 is populated for both components. Then create another peak, real CF, search order Result Set Only, and the formula is CF_1*(CConst2/CConst1)*100 and call it CF_2.

    If you want to, try and make the formula with one CF, such as

    (S1.%..AVE(Area)/S2.%..AVE(Area))*(CConst2/CConst1)*100, but sometimes Empower wont work with longer formulas, so that's why I split it up. And remember to put Summarize Custom Fields as the last line of the sample set, which you need for the AVE part of the CF to work.

  • egio
    egio
    Options
     

    I thought it could be done using only the sample weight dilution field and control function in the sample set.
thank you very much I will try to make the formula.

Categories