You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to show a calculation output just one time (not in a column for every record)?

Received Response
edited Mar 21, 2016 8:23PM in Reporting & Analytics for B2C Service 1 comment



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.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!