5 Replies Latest reply on Oct 22, 2019 11:30 AM by Jerry Casey

    [nQSError: 42039] Columns in BY clause of REPORT totalling function must be in select list

    Dennis Hancy

      I have an analysis that includes a column with this formula:


      IFNULL('@{pv_FileName}',"ReportTable"."File Name")


      "ReportTable"."FileName" is part of a hierarchy in my analysis.  I also include this field as a hidden column on my report.


      @{pv_FileName) is a presentation variable I set via a prompt.  It is being populated correctly.


      I am getting the error in the subject line when I run this.



      One posting I saw on this subject said that a bug was open for this issue (Bug 12664636), although that was eight years ago.


      Another posting I saw suggested unchecking the box "Report-Based Total (when applicable)".  I tried this on both my "IFNULL" column as well as the hidden "ReportTable".FileName" column.  But I am still seeing the error.


      Any suggestions?  Thanks!