Report Complex Filter

[Sloff]

Hi

I'm trying to setup a filter in a report that compares two dates with each other, but I keep receiving an error, I'm not sure how the expression should be. Please see an example attached

[yuri]

Hi,

Such are expressions not supported. Formula can not handle record values in this case.

You can create not storable field that will calculate difference between two columns and then it can be utilized in the filter.

[Sloff]

That would be perfect, could you point me towards an example of such a field (non storable and calculated by other values)?

[Sloff]

It seems that I should mark it as notStorable within the entityDef, and then set a value within the Service's loadAdditionalFields method, is that correct?

[tanya]

Try this way

https://forum.espocrm.com/forum/general/34663-report-filter-for-comparing-values-of-2-float-fields

[Sloff]

Awesome, thanks Tanya and Yuri