reportFilter in Formula and Advance Pack

[item]

Hello Yuri,
on demo too :

https://docs.espocrm.com/administration/formula/#filter

reportFilter seemt not working.

i have create a calculed field amount on Account
on formula : amount=entity\sumRelated('invoices', 'amount', 'reportFilter6160303f6cb089d6d');
i have create a report type List Invoices with filter anyOf status=Confirmed

expected result = 0
result is sum of amount.

it's seem the filter is not used.

it's actually on demo

Best Regards

[yuri]

Hi,

As usual, tried to reproduce but it worked for me.

[item]

Hello Yuri,

https://demo.eu.espocrm.com/#Account/view/53203b94286d1

https://demo.eu.espocrm.com/#Report/...0303f6cb089d6d

I will ask for other telecastg .. emillod .. can you try and say if OK for you ?

amount=entity\sumRelated('invoices', 'amount', 'reportFilter6160303f6cb089d6d');

Best Regards

[yuri]

Not a bug. You made it wrong. Check the docs. You need to created Report Filter, not just Report. https://docs.espocrm.com/administration/formula/#filter

[item]

Mea Culpa Yuri,

reportFilter is on Admin .. not on Report Entity

Sorry