Skip to main content
Solved

Trying to filter on a Calculated data difference field


wfilipiak67
Captain II
Forum|alt.badge.img+3

Hi, 
I created a GI trying to get the customers that are over the days past use. 
I am then trying to calculate the number of days past the Credit Due days of the oldest invoice. 

The data is displaying the way I expected it to. 
My issue is that I cannot apply a GI filter on the Day Past Credit Grace Period. If I enter 120, nothing appears even though in the All records tab, there are records that meet this requirement. 

These are the fields that I am using for the calculations. 
Thank you in advance. 

Bill
 



 

Best answer by lauraj46

Hi @wfilipiak67 ,

The formula results are being interpreted as text.  Some hints are that the data is left justified in the column, and also if you try to do a Quick Filter on the column the filter options do not include Greater Than or Less Than.  

To ensure that the result is converted to a number, specify a Schema Field that is of a numeric data type.  I tested this as shown below and it seemed to do the trick.

Hope this helps!

Laura

View original
Did this topic help you find an answer to your question?

4 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 502 replies
  • March 1, 2023

Hi @wfilipiak67 ,

Please post the xml code for your GI and I will be glad to take a look.

Laura


wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • 98 replies
  • March 2, 2023

@lauraj46 , 
Here is the xml of the GI. 
We are trying to create a filtered tab to the GI. The sorting of the column is working. 

Thank you for the assist. 
Bill


lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 502 replies
  • Answer
  • March 2, 2023

Hi @wfilipiak67 ,

The formula results are being interpreted as text.  Some hints are that the data is left justified in the column, and also if you try to do a Quick Filter on the column the filter options do not include Greater Than or Less Than.  

To ensure that the result is converted to a number, specify a Schema Field that is of a numeric data type.  I tested this as shown below and it seemed to do the trick.

Hope this helps!

Laura


wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • 98 replies
  • March 3, 2023

@lauraj46 ,
Thank you very much!
Setting the schema worked great!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings