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. Image for the cookie policy date

Advanced Filtering is not working when the format is set to currency.

AspNetCore Version="2.0.0"
Syncfusion.EJ.AspNet.Core Version=""
Syncfusion.EJ.Pivot" Version=""

<ej-pivot-client id="PivotClient1" title="Relational Browser" render-success="successEvent" load="onLoad">
<e-data-source enable-advanced-filter="true">
<e-row-field field-name="Country" field-caption="Country"></e-row-field>
<e-column-field field-name="Product" field-caption="Product"></e-column-field>
<e-value-field field-name="Amount" field-caption="Amount" format="currency"></e-value-field>

I have attached a video that shows that behavoir.

Attachment: advancedFiltering_14d0f3a.zip

3 Replies

SU Suriya Syncfusion Team December 4, 2018 06:01 AM UTC

Hi Eduardo, 
Sorry for the inconvenience caused. 

We confirmed that “Value filtering is not working properly in advanced filter while changing the number format” is an issue and we have logged a defect report. The fix will be included in the Essential Studio Volume 4 release which is estimated to be available by the mid of December. 


ED Eduardo December 4, 2018 05:55 PM UTC

Thanks for your response.

Ok, I will waiting the release.

Eduardo Viñuela

SA Scintilla Arul Jothi Raj Syncfusion Team December 18, 2018 11:26 AM UTC

Hi Eduardo, 
We are glad to announce that our Essential Studio 2018 Volume 4 Release v16.4.0.42 is rolled out and is available for download under the following link. 
We have included the fix for the issue- Value filtering is not working properly in advanced filter while changing the number format” in this release. 
We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance. 
Scintilla A 

Live Chat Icon For mobile
Up arrow icon