If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

List Summary Calculating before Calculated Data Item

Started by SudoJustin, 18 Mar 2020 09:08:31 AM

Previous topic - Next topic

SudoJustin

I have a list with 3 main columns, [Budget], [Balance], and [Savings - Deficit]. [Savings - Deficit] is using the floor() function to round down to the dollar. So it looks like this:  floor([Budget]-[Balance]).

My problem is that when I summarize in groups and list, the summary for [Savings - Deficit] is totaling the raw values for [Budget]-[Balance], then applying the floor() function to that amount instead of totaling the already rounded values. I'm sure this is an easy fix, but I've tried a lot and haven't seen anything online quite like it. Most reference crosstabs and solve order.

I have [Savings - Deficit] aggregation set to calculated as well as Total(Savings - Deficit). I have tried mixtures of total and calculated, but can't get anything that looks right.

Thanks in advance for any help.