Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: nino191 on 21 Mar 2014 10:09:28 AM

Title: Transformer - FM Functions
Post by: nino191 on 21 Mar 2014 10:09:28 AM
Hello everyone,

I need to create a percentage from a unique field and transformer dont let me do it because it needs two parameters percent(metric A, metric B). As other option I did that calculation in cognos Framework percentage(Metric A) but Transformer rollup mess everything up.

You guys did it before ?

Thanks in advance,

Vitor Lamac
Title: Re: Transformer - FM Functions
Post by: nino191 on 21 Mar 2014 11:11:52 AM
Sorry for the double post but I solve my problem and would like to share it. I did an aggregation in FM that returned for me always the same value for all records. In the transformer I used minimum/maximum rollup and did the calculation (Field A / Field A From FM).

Thanks,

Vitor Lamac
Text only | Text with Images