Number of values in calculations

Hello! 
I have some trouble trying to find and get the following. In a calculation obtained by a formula, is it possible to know how many value are taken to get the result and not only the numeric result?

Welcome!

It looks like you're new here. Sign in or register to get started.

Comments

  • Every part of the calculation will use the full amount of background decimals to produce the final result. For example, a formula of (Area*10)\Retention Time would take the full value of Area of a peak (say 101456.3098109867..etc) multiplied by 10, then divided by Retention Time of that peak (say 2.3456610988 etc) to give a final result. Empower displays a max precision of 14 decimal places for real numbers but Oracle uses 17 digits in the background. Each field is considered to its full value unless you ROUND it in a formula. 
  • I think I did not explain my issue clearly.
    The fact is: letś say that I have 7 data (2, 4, 6, 8, 1, 3, 5) and I create a custom fields that says: add all the values above value 4 (so then 6, 8, 5). What I get is a nummeric value (19 for this example).
    What I wonder is whether you can also get something like "the number of values that were added" (in this case 3).

  • shaunwat
    edited May 2022
    Using your example above...

    Custom Field 1 (boolean): GTE(CustomFIeld, 4) --- this will place a 1 if "true" and a 0 if "false"
    Custom Field 2 (peak, real): SUM(CustomField1)

    This will not tell you which results were summed, but it would tell you that three values were used to generate the sum). 
  • Thank you very much!!!
  • Custom field 2 would have to be a Result Real CF not a peak one. Presuming you want a result for each injection, then you would have to make CF2 Result, as you cant sum a peak field unless its part of an intersample calculation. So if you wanted the sum over standard injections like S1 S2 etc then your formula is peak real: S%.%..SUM(CF_1) but SUM(CF_1) on its own as a peak cf will give an error message. 
  • A simple logic is Sum/Average will give count

Welcome!

It looks like you're new here. Sign in or register to get started.