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
47
Views
1
Comments
edited Mar 21, 2016 8:23PM in Reporting & Analytics for B2C Service 1 comment

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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