Reporting and Analytics for Service

Get Involved. Join the Conversation.

Topic

    David Soto
    How to show a calculation output just one time (not in a...
    Topic posted March 21, 2016 by David SotoBronze Medal: 1,250+ Points 
    114 Views, 1 Comment
    Title:
    How to show a calculation output just one time (not in a column for every record)?
    Content:

    Hi, 

    EXAMPLE: We have a report that has a calculated column of "Total Time" (sum (......)), and another calculated column of "Total Quantity" (another sum (......)).  

    We want to show the "TOTAL AVERAGE" that is Sum(TotalTime) / Sum(Total Quantity). This is the calculation of two separate columns (that's why I can't use the standard "average" option).

    I have the expresion to calculate it, but I don't know how to show it just in one output (not a column, because it would show in every record.). Is there a way?

     

    I tried to put in in a Variable & show it in a Text Field, but the Text Field is showing the expresion, not the calculation. I am attaching you an image.

     

    Can you help me?
    Thanks in advice.
    David

    Version:
    May2015
    Document:

    Comment