CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

How to add calculations to a narrative in a report

edited Feb 28, 2015 10:01AM in CRM On Demand - Reports and Dashboards (MOSC) 3 commentsAnswered

I need to add almost like a header to a report with something like this:

Region: <this comes from a prompt filter I am adding>

FY YTD Points Won: <this number needs to be the sum of all values in Column 5>

% of Target: <this number needs to be the percentage of Points Won (sum of all values in Column 5) vs Target Points (which is a fixed value I have)

I now how to add the column itself to the narrative using the @ but that just shows all values one after the other one.

Your help is greatly appreciated it!

Cristina

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center