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

Formula editor does not handle complex terms properly

    XMLWordPrintable

    Details

    • 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.

      Description

      Edit the following formula:

      =IF(CONCATENATE(FIXED(((["Column1"]/["Column2"])*100);2);" %")>0;"True";"False")

      when you select the IF, you will see that the condition-term misses one closing parenthesis, thus causing the true and false branches to display the wrong values.

        Attachments

          Activity

            People

            Assignee:
            mleite Margarida Leite
            Reporter:
            tmorgner Thomas Morgner
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: