Print Page - Reporting difference between transformer cube and fm model

Title: Reporting difference between transformer cube and fm model
Post by: cognos05 on 21 Mar 2019 08:23:53 AM

Hi ,

I have two records

Material1 Sales 14.50
Material2 sales 29.00

In transformer material 1 shows 14, and material 2 shows 29 and Sum of materials shows 34
In FM Package material 1 shows 14, and material 2 shows 29 and Sum of materials shows 33.

How can i make the FM sum to show the rounded sum to nearest value 34 .

Thanks,

Title: Re: Reporting difference between transformer cube and fm model
Post by: CognosPaul on 21 Mar 2019 09:55:39 AM

My initial thought was the default rounding rule is causing an issue here, but that's roundEven. Can you set the decimal precision to 2 in the list (and in the total row) and see what the values are?

Title: Re: Reporting difference between transformer cube and fm model
Post by: cognos05 on 24 Mar 2019 09:25:58 PM

In the fm model its not bringing decimal values, should we chnage some settign in fm model.

Title: Re: Reporting difference between transformer cube and fm model
Post by: CognosPaul on 24 Mar 2019 10:20:35 PM

Is it a data format issue? What happens if you multiple the value by 100?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: cognos05 on 21 Mar 2019 08:23:53 AM