COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => PowerPlay Studio => Topic started by: dtopicMedV on 28 Oct 2011 02:35:20 PM

Title: Calculation formatting in C8.4.1 Powerplay Studio
Post by: dtopicMedV on 28 Oct 2011 02:35:20 PM
Hi,

In the Power Play Transformer cube model, I have two measures Amt1 and Amt2 formatted as $$$.
I don't want to calculate Amt1/Amt2 In the cube model.
Instead, I would like our users to perform that calculation in the Power Play Studio.
But, when they do that, calculation is formatted as  $$$.
I can't find any way to change format in the Power Play Studio from $$$ to plain number.

Anybody has any idea?

Thanks a lot!