set Number format for data fields

[chaitanya]

could you please let me know how to set number format for below if a data field is created like below :

pt.DataFields.Add(pt.PivotFields("OnHand"), "SUM of OnHand", SubtotalTypes.Sum)

[amy.zhao]

Dear chaitanya,

Thanks for your inquiry.
Pleae try the code below.

Code: Select all

 pt.PivotFields("OnHand").NumberFormat = "0.00";

Regards,
Amy
E-iceblue support team

[amy.zhao]

Dear chaitanya,

Has this issue been resolved?
Please give us a feedback at your early convenience.

Regards,
Amy
E-iceblue support team