Undefined Percentage Values in Calculated Column in PivotGrid Control in ASP.NET MVC

[Jeffrey Stone]

Hello,

I am using a calculated column in the PivotGrid in ASP.NET MVC and have several issues:

1) When using a percentage format the calculation is displaying "NaN.00 %" in situations where the values in the computation are undefined. How can I get a nice blank value to display (note - it seems to be an issue with the percentage format as without the percentage format a blank is displayed) ?
2) When using a percentage format I have to multiple the percentage by 100 to get the correct number to display - why is this?
3) Really just a question - is there any documentation on what can be put into a formula?

BTW Incident #157635 was opened where this feature was added to the PivotGrid. Unfortunately, I couldn't get around to testing the feature once you all added it as I was busy on other activities.  Other than the above issues, I really like the functionality.

I have the computed column defined as follows:
{
    fieldName: "SlippagePercent",
    fieldCaption: "Slippage %",
    isCalculatedField: true,
    formula: "100 * SlippageAmount / FillAmount",
    format: "percentage"
}

Regards, Jeff

[Sastha Prathap Selvamoorthy]

Hi Jeffrey, 

Thanks for using Syncfusion products. 

Please find the response below. 

1) When using a percentage format the calculation is displaying "NaN.00 %" in situations where the values in the computation are undefined. How can I get a nice blank value to display (note - it seems to be an issue with the percentage format as without the percentage format a blank is displayed) ?	We have created an incident to log an issue report on behalf of you. Our support engineer will assist you through incident. We request you to follow with the incident for further details.   https://www.syncfusion.com/account/login?ReturnUrl=/support/directtrac/incidents
2) When using a percentage format I have to multiple the percentage by 100 to get the correct number to display - why is this?
3) Really just a question - is there any documentation on what can be put into a formula?	Please find the below documentation link for your reference.  Documentation Link: http://help.syncfusion.com/aspnetmvc/pivotgrid/calculated-field

Regards, 

Sastha Prathap S.