Using PercentDifferenceFromPrevious function within a CalculatedAggregateDescription based on a calculated field has unwanted side effects

[Chris]

Hi all,

I´ve attached a screenshot of a behaviour within the PivotGrid I do not understand. When adding a calculated field making use of the TotalFormat "PercentDifferenceFromPrevious", the underlying column used for the calculation is formatted as percentage value? How can I overcome this issue? Changing the NumberFormat within the PropertyAggregateDescription for "Sum of Sensitivity" does not have an effect.

 

EDIT: Placing the calculated field "%-Diff. Sensitivity" before the "Sum of Sensitivity" field using Drag&Drop on the values field of the PivotFieldList eliminates this bug. I can also set the number format of "Sum of Sensitivity" then as I wish to.

Could you suggest a walkaround for me?

Regards,

Chris

[Vladimir Stoyanov]

May I ask you to share a sample project demonstrating the observed on your end behavior? Note, that you can use the LocalDataSourceCalculatedFields RadPivotGrid SDK example as a startup point, if you find that more convenient. 

This will hopefully allow me to investigate the exact scenario and further assist you.

[Vladimir Stoyanov]

Hello Chris,

Thank you very much for the shared project and additional steps. 

I was able to replicate the described behavior on my end and I have logged it in our feedback portal: PivotGrid: String formats can be mixed when adding a calculated field along with its required field as aggregate values, where you can track its progress. I have also added some telerik points to your account as a thank you for your involvement. 

For the time being, as a workaround, you can create a new AggregateValue instance in the CalculateValue override of the custom field and copy the properties of the original instance. I am attaching the sample project back modified to demonstrate what I have in mind. Note, that I have added this logic in the PercentDiffCalculatedField, however you can transfer it to other calculated fields as well.  

Regards,
Vladimir Stoyanov
Progress Telerik

[Chris]

Hi Vladimir,

thanks a lot, that helped. The data is displayed correctly now :-)

As a sidenote: The export function of the PivotGrid is also affected by the bug. Columns are exported incorrectly as percentage values. That was actually the issue that brought me to this point.

Regards,

Chris

 

[Vladimir Stoyanov]

I am glad to hear that you found the suggested approach helpful. 

Thank you for the additional info. I will update our internal item with it. 

[Chris]

Hi Vladimir!

I wasn´t aware of the support tickets option - thanks for pointing that out :-)

I´ve attached a screenshot and an example program reproducting the error I stated. Could you please have a look at that?

Thanks in advance,

Chris