We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Thread ID:

Created:

Updated:

Platform:

Replies:

125046 Jul 17,2016 06:45 PM UTC Jul 18,2016 09:02 AM UTC ASP.NET MVC 1
loading
Tags: PivotGrid
Jeffrey Stone
Asked On July 17, 2016 06:45 PM UTC

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 [Syncfusion]
Replied On July 18, 2016 09:02 AM UTC

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. 




Regards, 
Sastha Prathap S. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;