Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-6066

Libformula SUMA, MINA, MAXA, and AVERAGEA functions do not compute correctly

    XMLWordPrintable

    Details

    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Sprint Team:
      Tatooine (Maint)

      Description

      SUMA, AVERAGEA, MINA, and MAXA are all supposed to compute values that are not parseable as numbers as 0.  Instead of parsing non-numeric values as 0, these functions return null when a non-numeric value is provided.

      For example these functions should return:

      • SUMA(5;5;"ABC") = 10
      • AVERAGEA(3;3;"ABC") = 2
      • MINA(5;5;"ABC") = 0
      • MAXA(-1;-2;"ABC") = 0

      But instead they return null.

        Attachments

        1. AVERAGEA_Validation.png
          AVERAGEA_Validation.png
          52 kB
        2. MAXA_Validation.png
          MAXA_Validation.png
          52 kB
        3. MINA_Validation.png
          MINA_Validation.png
          52 kB
        4. SUMA_Validation.png
          SUMA_Validation.png
          53 kB

          Activity

            People

            Assignee:
            vasco.marques Vasco Marques
            Reporter:
            cdeptula Chris Deptula
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: