I'm using Cognos Report Studio. I'm pretty new to the software. But anyway, I've created a query that is meant to count the number of days between two dates. There are multiple records and I need the average of all the days. I'm able to do all of this. But my result is 6.57254211... I want this number to be rounded. But I can't seem to figure out how to do this. I achieved the average by applying an aggregate function. I though the round would be applied the same way. But there is no Round in the rollup aggregate function option. I also tried to use _round() in my data item code, but that returned an error. Plus, I'm pretty sure that just rounds each individual number I get, not the average of all of them. Anyone know how to do this?
Cognos: How to round an average of a data item result
1.2k views Asked by woods At
1
There are 1 answers
Related Questions in REPORTING
- Can you report real-time visitors to your website using Mixpanel
- Add a eps file or pdf file to my report - MATLAB Report Generator
- I want to generate PDF automation report in XUnit using selenium driver and .net in visual studio?
- do you know any free reporting services like devexpress or boldreports?
- error NU1101: Unable to find package Telerik.Drawing.Skia.Trial. No packages exist with this id in source(s)
- Customization to Last Week filter
- Showing Different Sub-Reports Depending on a User Driven Parameter
- ASP.NET session has expired or could not be found in webforms app inside an iframe
- Row in Power BI Table blank
- xcresults tool is not able to export screenshots for failure cases ( xcresults-1.17.1 )
- how to create a textbox in ssrs for user entry as a parameter and limit the Character input to 18
- How do I find out where this error is coming from?
- Unable to call a custom dll method in Microsoft SSRS
- How-to export NUnit Attributes in one file/report
- Will reports still be accessible once an App is removed from Sale from the Apple Store
Related Questions in AVERAGE
- Moving Average of a variable frequency signal
- Finding average of numbers excluding -1
- How to Sum Values by Column 'Date' After Averaging by Column 'Site'?
- Calculate the average of a filtered list/column with a condition (libre office calc)
- Excel - Aggregating Data in One Column Based on Values in Another Column
- DAX, Calculating Average of a measure within a hierarchy
- I have an array of percentages I want to find the average to
- Can't use double, can't use int, what do I use to stop the rounding? (Java)
- How to calculate an average value based on K-nearest neighbors?
- The average results are calculated differently by the same average measure in the DAX for different time periods
- Averaging Multiple Ranges to ignore 0's and N/As
- Split budget column by total number of months to give average monthly budget
- Pairwise differences between rolling average values for different window widths
- Averaging between several arrays javascript
- How to calculate a daily sales average based off the working days in a month
Related Questions in ROUNDING
- In the python fractions module, why is a result of round() sometimes incorrect?
- How to round values in pyplot table
- why does the default round function in python fix double rounding errors?
- SSRS - Do not want to round a percent
- Understanding Python's Decimal.quantize method
- Isometric Tilemap is Not Lining Up Properly
- Algorithm for rounding and clamping a number to specific ends
- Character and Numeric vectors, preserve decimal points in R
- Rounding error for residuals in GARCH mean model
- Why does gcc -O1 affects std::rint()?
- How can I round numbers with three or more digits after the decimal point accurately?
- How do I make the rounding function of athena match redshift?
- Rounding of binary floating point number's mantissa
- Round prices in woocommerce without rounding the total tax at cart and checkout
- Floating point serialization/parsing rounding
Related Questions in COGNOS-8
- IBM Cognos IF/casewhen + _days_between
- Cognos Analytics 11.x - Find database vendor type in a query subject definition
- Cognos Report Studio: CASE and IF Statements
- Join and max date with null values
- Filter the data in one query based on the result from another query in Cognos
- CognosTM1 Error: Syntax Error on or before Value
- Cognos : create custom groups in report studio
- Applying custom colors to bar charts in Cognos11
- Migrating Reports From Cognos8 to SSRS Report Builder 3
- CASE statement in Report Studio filters
- Congnos Ranking lowest as Rank 1
- Cognos framework join issue
- sqlopenresult' status='-239' / cognos report error
- Cognos Reports are not distributed to al the mail id's
- Need help building a Data Item in Cognos Report Studio
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
I was able to round my average by creating a query calculation and doing _round([Weekdays]) for the code. [Weekdays] being the average I need rounded.