Uploaded image for project: 'LIMS'
  1. LIMS
  2. LIMS-1769

Allow to use LDL and UDL in calculations

    Details

      Description

      The user must be able to get the value of LDL or UDL in calculations instead of the Analysis result by using specific wildcards. As an example, calculations could look like the following:

      'Not detected' if [AS1_KEY.BELOWLDL] else [AS1_KEY]/[AS2_KEY]
      'Undeterminate' if [AS1_KEY.ABOVEUDL] else [AS]
      [AS1_KEY]*[AS2_KEY] if [AS1_KEY] < [AS1_KEY.LDL] else [AS1_KEY]*[AS2_KEY]*[INTERIM_1]
      

      where AS1_KEY is the keyword of a dependent analysis and INTERIM_1 is the keyword for an interim field.
      BELOWLDL, ABOVEUDL, LDL and UDL are wildcards relating to Limit Detections

        Issue Links

          Activity

          Hide
          xispa Jordi (Inactive) added a comment - - edited

          Leo, pushed to your hotfix/3.1.8. You need to do a Ctrl+F5 after the pull.
          Accepted operands/wildcards in calculations:

          - [INTERIMKEY]: (float) interim's value
          - [ASKEY]: (float) analysis result
          - [ASKEY.LDL]: (float) analysis' Low Detection Limit (default or manual)
          - [ASKEY.UDL]: (float) analysis' Upper Detection Limit (default or manual)
          - [ASKEY.BELOWLDL]: (bool) if the result is below LDL
          - [ASKEY.ABOVEUDL]: (bool) if the result is above UDL
          

          Some examples of formulas:

          [AS1.LDL]+[AS2.LDL]+[INTERIM1]
          '< LDL' if [AS2.BELOWLDL] else [AS2]*[AS1]
          ('> '+[AS2.UDL]) if [AS2.ABOVEUDL] else [AS2]+[INTERIM1]
          [AS1] If ([AS2.BELOWLDL] or [AS2.ABOVEUDL]) else [AS2]
          
          Show
          xispa Jordi (Inactive) added a comment - - edited Leo , pushed to your hotfix/3.1.8. You need to do a Ctrl+F5 after the pull. Accepted operands/wildcards in calculations: - [INTERIMKEY]: ( float ) interim's value - [ASKEY]: ( float ) analysis result - [ASKEY.LDL]: ( float ) analysis' Low Detection Limit ( default or manual) - [ASKEY.UDL]: ( float ) analysis' Upper Detection Limit ( default or manual) - [ASKEY.BELOWLDL]: (bool) if the result is below LDL - [ASKEY.ABOVEUDL]: (bool) if the result is above UDL Some examples of formulas: [AS1.LDL]+[AS2.LDL]+[INTERIM1] '< LDL' if [AS2.BELOWLDL] else [AS2]*[AS1] ('> '+[AS2.UDL]) if [AS2.ABOVEUDL] else [AS2]+[INTERIM1] [AS1] If ([AS2.BELOWLDL] or [AS2.ABOVEUDL]) else [AS2]

            People

            • Assignee:
              xispa Jordi (Inactive)
              Reporter:
              xispa Jordi (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Agile