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

Reporting difference between transformer cube and fm model

Started by cognos05, 21 Mar 2019 08:23:53 AM

Previous topic - Next topic

cognos05

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,

CognosPaul

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?

cognos05

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

CognosPaul

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