rounding values in transformer.

[navpatel]

Hello Everyone...

I have a calculated KPI in transformer i.e. C = A/B now A and F are both coming from Netezza and then FM package as a source to transformer.. The issue is that i have applied data format to C as 2 decimal places.

When i run my report though it displays 2 decimal places in the report but when this report is exported to excel and when we click on the cell that contains value for C it display upto 12 decimal places...i.e. the formatting function is just for display and does not actually rounds up the value.. This is also an issue when i am trying to compare the value of this measure with another measure as it displays 2 decimal places but ends up comparing the value with 12 decimal places which is the actual one...I am not able to use round function in transformer...I have work around in report studio to use another data item with ROUND(c,2) but i want to give the same value from the transformer itself .....