Customer Portal

Get Involved. Join the Conversation.

Topic

    R P
    Report with calculated columns do not work on CP
    Topic posted January 22, 2019 by R PRed Ribbon: 250+ Points 
    35 Views, 1 Comment
    Title:
    Report with calculated columns do not work on CP
    Content:

    Currently we have a report with a calculated column which does not show column values on Customer portal at all when tried to use with grid or multiline widget. Has anyone run into this issue before?   

    When researched, we noticed PHP API does not allow to get report results when report has calculated column. Are there any workarounds?

    Comment

     

    • Scott Heidenreich

      Did you add the calculated field as the last column in the report?  If so it may not be passing through the grid widget.  Try moving the calculated field to the first or second column in the report and see if it works - this is assuming you are using standard analytics functions and not custom scripts...