Number Formatting in Pivot

[v_jaideep]

Hello Experts,

In the Pivot table, I have few columns where data formatting is not happening as expected. Especially if there is data apart from 0.

From the below snapshot:

Minor and Failure Rate columns have repeated data values. Though I have reduced number formatting to 2 decimal(#,##0.00). Any suggestions please to overcome this issue.

[Chanty4u]

try to do in this script..

NewTable:

Load *,

     Round(Field1,0.01) as Field2

Resident T1;

Drop Table T1;

or try this directly

Num(round(Field1,0.01), '# ##0,00 ')